Need help - simplifying a formula

Copper Contributor

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

 

2 Replies

Hi Ewan,

 

Do you mean IFERROR()?

Hola te puedo hacer las preguntas en español?