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

 

[harrenst]

Hi. I made a personal budget spreadsheet that has this in the H11 cell:

=CEILING(0.1*(H4+H6+H7),"5")

It adds H4, H6 and H7, multiplies it by 1/10, then rounds the answer up to the nearest 5. That's all good except now I'm having times when H4 is greater than zero, but less than 5, and H6 and H7 are zero. Per my formula, the result is 5. I need it to be zero. I tried IF(H4<=5),(=CEILING(0.1*(H4+H6+H7),"5","0")) but it's not working. I've tried the insert function button. The "0" is right, but the ceiling part comes up as invalid and I can't figure out what to change to make it work. Am I not allowed to have two "=" signs in there? Am I missing a comma or parenthesis or space? Eeeeek help!

 

[T. Valko]

Hi. I made a personal budget spreadsheet that has this in the H11 cell:

=CEILING(0.1*(H4+H6+H7),"5")

It adds H4, H6 and H7, multiplies it by 1/10, then rounds the answer up to the nearest 5. That's all good except now I'm having times when H4 is greater than zero, but less than 5, and H6 and H7 are zero. Per my formula, the result is 5. I need it to be zero. I tried IF(H4<=5),(=CEILING(0.1*(H4+H6+H7),"5","0")) but it's not working. I've tried the insert function button. The "0" is right, but the ceiling part comes up as invalid and I can't figure out what to change to make it work. Am I not allowed to have two "=" signs in there? Am I missing a comma or parenthesis or space? Eeeeek help!

Maybe this...

=IF(H4+H6+H7<=5,0,CEILING(0.1*(H4+H6+H7),5))

 

[harrenst]

Wow. It works, it absolutely works! You are the most awesome person ever!
Thank you thank you thank you!

 

[T. Valko]

Wow. It works, it absolutely works! You are the most awesome person ever!
Thank you thank you thank you!

You're welcome. Thanks for the feedback!