IF formula

[blu_eyed_jen]

I am trying to to a formula with the the following formula =IF(G157-(S103-O157)<0,"YES","NO") this part works but my problem is that I need to add on to it so that if cell g157 and O157 are blank that it will come up with a result of "N/A".

[rylo]

Hi

Can you please edit your post to show a subject that is more relevant to your post.

A solution:
=IF(AND(ISBLANK(G127),ISBLANK(O157)),"N/A",IF(G157-(S103-O157)<0,"YES","NO"))

rylo

[blu_eyed_jen]

Question yesterday: I am trying to to a formula with the the following formula =IF(G157-(S103-O157)<0,"YES","NO") this part works but my problem is that I need to add on to it so that if cell g157 and O157 are blank that it will come up with a result of "N/A".

Problem today: Thanks for the solution but it didn't work and i don't think I was clear as to the result I need. The formula needs to look at G157 and/or O157 and if both of them are blank it will come back with "NA" but if one is blank that it only uses the cell with the value in it to come back with YES or NO. Can you help with this? Thanks so much!

[rylo]

Hi

1) I mistyped the cell reference G127 SB G157.
2) If that doesn't fix the problem, then attach an example workbook. Are both the cells really blank, or do they have a space? Is the result of a formula that produces ""???


rylo

[blu_eyed_jen]

I had noticed the typo and put it in the spreadsheet correctly but it didn't work. Actually the cells do have formulas in them and to calculate totals if values are put in other cells. I am attaching the workbook which I modified so it was small enough to send but it still shows what I need but obviously my cell numbers have changed. I have put an explanation and shapes on it to help you figure out what I am trying to accomplish. I apologize if I have not been easy to understand. Thanks for the help.

[rylo]

Hi

Can you please resave your workbook in excel 2003 format.

rylo

[blu_eyed_jen]

I am trying to get the formula in Cell F6 to do this: When there is an amount in cell E2 and cell D6 is "blank" (which populates from H3 if there is an amount in it) AND cell B6 is "blank" (which populates from B4 if there is an amount in it) that I will get a result of N/A in cell F6. Also if cell B6 is "blank" but cell D6 has a value that the result in F6 will be N/A.
Note: I did change my question a little bit because I realized that I had not put it in correctly.

Thanks again for your time.

[ratcat]

G'day

Try this

Please Login or Register  to view this content.

[blu_eyed_jen]

It worked..........thank you so much!!! I have been racking my brain on this for days!