disregarding cells

[bronwyn]

hi there, I have a cell with the formula =AM20-AL20 in it. What i would like to do is that am20 is a calculated cell. If am20 does not have a value in it, then i would like to disregard this so that i do not get a value error in the cell next to it, please help!!!!!

 

[Pekkavee]

Would this do it

=IF(ISNUMBER(AM20),AM20-AL20,"No value in AM20")

 

[Todd Bardoni]

Or:-

=IF(AM20="","",AM20-AL20)

Or:-

=IF(AM20,AM20-AL20,"")

Pekkavee,
You don't need to use ISNUMBER. My second formula will do the same thing as yours.

 

[bronwyn]

thanks very much, all work

 

[Aladin Akyurek]

Or:-

=IF(AM20="","",AM20-AL20)

Or:-

=IF(AM20,AM20-AL20,"")

Pekkavee,
You don't need to use ISNUMBER. My second formula will do the same thing as yours.

Since the OP states that AM20 houses a formula with apparently delivering either a number or a formula-blank, the second formula you're referring to will fail with formula-blanks.

The first formula and one with ISNUMBER would cover the same ground if AM20 is empty or houses either a number including a real 0 or a formula-blank. If one wants to exclude the real 0's, then:

=IF(N(AM20),AM20-AL20,"")

would be the course to take.

 

[Todd Bardoni]

Thanks, Aladin.

My apologies Pekkavee.