Multiple if formula

[dunmore83]

Hi Everyone,

I am have the following scenario I need some assistance with:

- If I10 has a "YES" value then I want cell I11 to check if I8 is greater than F9.... if it is then cell I11 needs to display "NO" but if I8 is not greater than F9 then I need cell I11 to display the value from cell F10.

I hope this makes sense.

If you need anymore clarification please let me know.

Thanks for your help!!!

 

[VoG]

Try

=IF(AND(I10="YES",I8>F9),"NO",F10)

 

[dunmore83]

Thanks!!

Almost I need to add one more variable to the formula you provided.... I10 can also have a "NO" value. If I10 is "NO" then I11 needs to be "N/A".

cheers

 

[VoG]

Maybe

=IF(I10="NO",NA(),IF(AND(I10="YES",I8>F9),"NO",F10))

 

[dunmore83]

cheers... almost got it

The only minor error is when I10 is NO I11 returns "#N/A".

Any suggestions to make it just return N/A without the #...??

thanks in advance

 

[VoG]

Try

=IF(I10="NO","N/A",IF(AND(I10="YES",I8>F9),"NO",F10))