Hi,
I am working on a report whereas, I am trying to get the 10% weight of certain data. However, when I tried to use the formula =IF(A1<=75,10,10-0.4*(100/A1)), it auto populates the cell to the 10% even if the base data is blank.
Please see screenshot.
How can I correct this?
Thank you.
Best,
Mharvz
It evaluates blank cells as zero, which is less than 75. You can conditionally format the cells to be white font if the value is zero, or nest an extra If function to test for blanks =If(ISBLANK(A1),"", IF(A1<=75,10,10-0.4*(100/A1)))
I'd use conditional formatting as this causes less problems later. Passing a zero length string back ("") may cause issues with other formulas when the rest of the cells are numbers.
Last edited by Neil_; 09-09-2016 at 01:29 AM.
Frob first, tweak later
Thank you.
To clarify:-
=If(ISBLANK(A1),0, IF(A1<=75,10,10-0.4*(100/A1)))
Then conditionally format the cells to be white if zero.
Thank you very much Neil. It works.
Best,
Mharvz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks