Hello,
Please can someone help.
I need to make the following IF formula a little longer.
=IF(J4>=G4,"Yes","No")
Basically I need it to also return a "No" value if G4 is Blank
You help is greatly appreciated!
Tom
Hello,
Please can someone help.
I need to make the following IF formula a little longer.
=IF(J4>=G4,"Yes","No")
Basically I need it to also return a "No" value if G4 is Blank
You help is greatly appreciated!
Tom
Last edited by moni_tm; 03-04-2015 at 03:20 AM.
Try it like this
=IF(G4="","No",IF(J4>=G4,"Yes","No"))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you AlKey.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks