Pl attach a workbook.
2 of 2 people found this helpful
[Column3] <- Calculation
IF( [Column1] = 'Severe' AND [Column2] = 'Booked within Period' ) THEN 'Booked within 2 Weeks'
ELSEIF ( [Column1] = 'Moderate' AND [Column2] = 'Booked within Period' ) THEN 'Booked within 2 Months'
Thank you Anisha,
That answered my question.
Happy to Help!
Good Job Anisha!!!
Thank you! Learning a lot from you
I see you cracking some hard ones Good..Good