If False, Do Nothing?
I'm Attempting to Make an Excel Formula Do Nothing If a Cell Is Blank, Is This Possible? This Is the Formula as It Stands, Could I Nest an If Statement That...
I'm attempting to make an excel formula do nothing if a cell is blank, is this possible?
This is the formula as it stands, could I nest an if statement that checks if F4 & G4 are blank and if they are it doesn't perform this formula?
=IF(F4 < G4, G4 - F4, TODAY() - F4)
...
Thanks!
3 Answers
=IF(F4&G4="","",IF(F4<G4,G4-F4,TODAY()-F4))
Figured it out...
=IF(F4 = "", "", IF(F4 < G4, G4 - F4, TODAY() - F4))
Woooooohoooooo
Try this: =IF(A1="M", "MALE", IF(A1="F", "FEMALE", "N/A")) Unfortunately, it's a bit verbose, but it will do what you need.
I hope this helps.
Josh
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
