Help with if formula within if formula

[dunmore83]

HI,

Can someone please help me???

In cell L3 I need to execute this formula... =IF((L8-I14)>0,"YES","N/A") but I only want this formula to run if the cell I10 contains the text YES. If the cell I10 contains NO I want the cell I10 to display N/A.

PLEASE HELP ME!!!!!

I have spent hours searching google & been unable to solve this.

Thanks in advance

 

[shg]

Welcome to the board.

=IF(AND(I10 = "yes", L8-I14>0), "YES", "N/A")

 

[Excelestial]

=if(or($I$10="No",l8-I14<=0),"N/A","Yes")

 

[dunmore83]

Thanks for the quick reply!!

It hasn't quite solved my issue. To clarify:

The formula in CELL L10 is.... =IF(L8-F8)>0,"YES","N/A")

- I only want this above formula to execute if the text in I8 is YES.

- If the text in I8 is NO then I want cell L10 to display N/A

Thanks again.

 

[T. Valko]

Thanks for the quick reply!!

It hasn't quite solved my issue. To clarify:

The formula in CELL L10 is.... =IF(L8-F8)>0,"YES","N/A")

- I only want this above formula to execute if the text in I8 is YES.

- If the text in I8 is NO then I want cell L10 to display N/A

Thanks again.

Maybe this...

=IF(I8="yes",IF(L8-F8>0,"Yes","N/A"),"N/A")

 

[Excelestial]

=if(or(l8-i14<=0,l10<>"yes"),"n/a",l8-i14)

 

[dunmore83]

Thank you so much T. Valko. Your formula worked!!!


I have another scenario I need help with:


I need to search the ROW I11:AG11 & return in CELL B22 the number found???


- to expand in ROW I11 to AG11 there will be only 1 number found. All other entries are N/A.


This forum rocks. Thanks everyone!!!!

 

[T. Valko]

Thank you so much T. Valko. Your formula worked!!!

You're welcome!

I have another scenario I need help with:


I need to search the ROW I11:AG11 & return in CELL B22 the number found???


- to expand in ROW I11 to AG11 there will be only 1 number found. All other entries are N/A.


This forum rocks. Thanks everyone!!!!

Try this...

=MAX(I11:AG11)

If there is no number in the range then that will return 0. If you want a blank returned instead, use this version:

=IF(COUNT(I11:AG11),MAX(I11:AG11),"")

 

[dunmore83]

Thanks that worked great!!!!

Another question??

In cell I11 I need it to return the value in CELL F10 but only return this value IF the value in I10 is YES & then only return value in cell I11 IF cell I8 is less than cell F9. Otherwise return value N/A in cell I11.

If you need any more clarification please let me know.

Really appreciate your help.

Cheers

 

[T. Valko]

Thanks that worked great!!!!

Another question??

In cell I11 I need it to return the value in CELL F10 but only return this value IF the value in I10 is YES & then only return value in cell I11 IF cell I8 is less than cell F9. Otherwise return value N/A in cell I11.

If you need any more clarification please let me know.

Really appreciate your help.

Cheers

I think this will do it...

Entered in I11:

=IF(AND(I10="yes",I8<F9),F10,"N/A")