Difficulty With Formula

[GoingPlaces]

Good morning. I am trying to write ONE formula that will do the following:

if F3="No" and F26 is blank then "Not yet approved" otherwise F26
if F3="Yes" and F30 is blank then "Not yet approved" otherwise F30

I've tried several techniques and have failed. I would appreciate any assistance.

Thank you.

 

[Joe4]

Welcome to the Board!
Try:
=IF(F3="No",IF(F26="","Not yet approved",F26),IF(F3="Yes",IF(F30="","Not yet approved",F30),""))

 

[GoingPlaces]

Thank you but it doesn't seem to be working. I had tried
=IF(F3="No",IF(F26="","Not yet approved",F26),IF(F30="","Not yet approved",F30)) but it only works if F3=Yes. If f3=No then it is always "Not yet approved" unless there is a value in F30 at which point it reflects that value.

 

[nuked]

How does it 'not work'. Do you get an error, or an unexpected value?

 

[Joe4]

Thank you but it doesn't seem to be working. I had tried
=IF(F3="No",IF(F26="","Not yet approved",F26),IF(F30="","Not yet approved",F30)) but it only works if F3=Yes. If f3=No then it is always "Not yet approved" unless there is a value in F30 at which point it reflects that value.

You might want to check your formula again to make sure you typed it correctly and didn't confuse F26 and F30.

If I use the formula and enter "No" in F3, and anything in F26, it returns the value from F26 (the "No" clause doesn't even look at the value in F30!).
That is what you requested, is it not?

If you think you have case that is not working, let us know exactly what you have in F3, F26, and F30 in your example, and what is being returned.
Also, if you haven't already done so, use Copy and Paste to copy my formula instead of trying to type it directly. That should eliminate any chance of keying errors when trying to type my formula.

 

[GoingPlaces]

It is working. Thank you so much. I had added a line to the sheet and didn't account for that in the formula. (Yes, I feel foolish).
Best regards.
Robyn