hi to all.. my question is how to return blank cell if i have no data inputted in left cell.. or if AH9 is blank or no data inputted AI10 will be blank using this formula..
=IF(AH9<75,"A",IF(AH9<82,"B",IF(AH9<87,"C",IF(AH9<92,"D","E"))))
hi to all.. my question is how to return blank cell if i have no data inputted in left cell.. or if AH9 is blank or no data inputted AI10 will be blank using this formula..
=IF(AH9<75,"A",IF(AH9<82,"B",IF(AH9<87,"C",IF(AH9<92,"D","E"))))
Last edited by clonedarkman; 03-10-2014 at 11:41 PM. Reason: Edit AH10 - AI10
Try below
=IF(AH9="","",IF(AH9<75,"A",IF(AH9<82,"B",IF(AH9<87,"C",IF(AH9<92,"D","E")))))
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
thanks sir HEMESH it works fine..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks