ExcelBanter - Logical test

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

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

- - Logical test (https://www.excelbanter.com/excel-discussion-misc-queries/9722-logical-test.html)

Sooraj

Logical test

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

R.VENKATARAMAN

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

Jim May

=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

All times are GMT +1. The time now is 04:12 PM.