Thread: Logical test
View Single Post
  #2   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

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