Hi,
How to make a logical test using IF to verify whether the
multiplication of 2 cells gives a number or gives an error.
IF(D5*C5=?????, TRUE, False). What should I put in place of ????
SGO

in any empty cell in the spreadsheet type

=ISNUMBER(C5*D5)

you will get either true or false
I am not using vba.

Sooraj wrote in message
om...
Hi,
How to make a logical test using IF to verify whether the
multiplication of 2 cells gives a number or gives an error.
IF(D5*C5=?????, TRUE, False). What should I put in place of ????
SGO

=IF(ISNUMBER(A3),"Got Number",IF(ISERROR(A3),"Got Error","You Got
Neither"))

"Sooraj" wrote in message
om...
Hi,
How to make a logical test using IF to verify whether the
multiplication of 2 cells gives a number or gives an error.
IF(D5*C5=?????, TRUE, False). What should I put in place of ????
SGO