LinkBack URL
About LinkBacks
Hello,
I need help with a basic formula.
In the attached sheet, I need cell I3 to return value 0 if cell A3 has no input (text or letters).
But if A3 has any value, e.g. W70DE, then formula "=MAX(19600;F3-G3-H3)" should take effect.
If cell has no input, then return 0
Hello,
I need help with a basic formula.
In the attached sheet, I need cell I3 to return value 0 if cell A3 has no input (text or letters).
But if A3 has any value, e.g. W70DE, then formula "=MAX(19600;F3-G3-H3)" should take effect.
Do you want this:Formula:
=IF(A3="","0",MAX(19600,F3-G3-H3))
or this:Formula:=IF(OR(A3="",A3=0),"0",MAX(19600,F3-G3-H3))
The second one caters for blank or zero in column A.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you, formula 2 was exactly what I needed
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks