I have a formula and i would like it return a blank cell if the cell that formula references is blank.
I have attached a sample.
Los
I have a formula and i would like it return a blank cell if the cell that formula references is blank.
I have attached a sample.
Los
e2=Please Login or Register to view this content.
Last edited by oeldere; 07-10-2014 at 10:45 AM. Reason: change b into A
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Add another IF to the beginning of the formula that checks for an empty cell:
=IF(A2="","",IF(A2>=70,"G",IF(A2>=60,"P",IF(A2>=0,"B",""))))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Formula:Please Login or Register to view this content.
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
AWESOME, Thank you
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks