May 29 2018
12:48 PM
- last edited on
Jul 31 2018
08:18 AM
by
TechCommunityAP
May 29 2018
12:48 PM
- last edited on
Jul 31 2018
08:18 AM
by
TechCommunityAP
At the moment I often use formula like this:
=IF(ISNUMBER(AT24),AT24/AW$32,"")
(check to see if a number is on cell AT24 and if there is then divide it by AW32 and give me the answer. Otherwise leave it blank.)
I want to use these formulas to show the difference between someone giving the answer 0 and leaving it blank, and also to keep rows blank that have not yet had critical data filled in. (It makes it harder to read and doesn't inspire confidence when 20 unused rows all have error messages like !VALUE or !DIV/0 in several columns...)
Surely there is a much more elegant way to do this, particularly when you need to do an extended error check using nested formulas - no point in having to have the computer check an extended calculation to see if the value is in range, just to then have to work out exactly the same calculation to display the answer...
Basically I want something like the old Nz(cell,value) function (if cell is null, use this value instead) in reverse so if this value i no good, send null. Maybe some error function?
Thanks
May 29 2018 02:44 PM