Simple IF

[david gabra]

Hi
I tired but no luck
An if statement that states:
if A5 = "Yes" then show "Print screen Needed"
if A5 = "No" then show "No Print screen Needed"
if A5 = is bank - then show "Please Select an Option"

thanks

 

[NARAYANK991]

Hi ,

Try this :

=IF(A5 = "" , "Please select an option" , IF(A5 = "YES" , "Print screen needed" , IF(A5 = "NO" , "No print screen needed" , "Invalid input , please select from YES , NO")))

Narayan

 

[david gabra]

It does not work.
The text does not change when No is selected

 

[NARAYANK991]

Hi ,

How are you entering data in A5 ? Is it just the two letters N and O or is there any leading or trailing space character ?

If you upload your workbook , it is a matter of a minute or two.

Narayan

 

[david gabra]

Thanks - see the column in yellow.

 

[vletm]

david gabra
Your 'No' has one extra mark in cell[O3].

Take it away!

 

[bosco_yip]

Remove trailing space behind cell O3.

Regards

 

[AliGW]

Try this:

=IF(TRIM(A5) = "" , "Please select an option" , IF(TRIM(A5) = "YES" , "Print screen needed" , IF(TRIM(A5) = "NO" , "No print screen needed" , "Invalid input , please select from YES , NO")))