ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - num! (https://www.excelbanter.com/excel-discussion-misc-queries/189835-num.html)

Pierre

num!

hi
i have :

A
1 10
2 #num!
3 #num!

how to compose the formula in cell B1 :
if A1 is NOT an error give me its value 10 ...and if false... 20

Tim879

num!

=IF(ISERROR(A1),20,A1)

use this formula and put it in another cell in the workbook.

if you want "20" to appear in cell a1, then you need to replace the
"a1" in the formula above with the formula that is generating the
error (i.e. =IF(ISERROR(A1/B1),20,A1/B1)

On Jun 3, 1:53 pm, pierre wrote:
hi
i have :

A
1 10
2 #num!
3 #num!

how to compose the formula in cell B1 :
if A1 is NOT an error give me its value 10 ...and if false... 20

All times are GMT +1. The time now is 02:28 PM.