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:
Please Login or Register to view this content.
or this:Formula:Please Login or Register to view this content.
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