Logical test

  • Thread starter Thread starter Sooraj
  • Start date Start date
S

Sooraj

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.
 
=IF(ISNUMBER(A3),"Got Number",IF(ISERROR(A3),"Got Error","You Got
Neither"))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where to put quotes in a SUMIF formula and when is & used for cell 2
ConditionalFormat-EndsWith, and logical Test IF 1
Unwanted single quote displayed in Formula bar 21
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
IF need to add a third value 6
Formula with mutltiple conditions 4
formula explanation 3
pricing help 5

Back
Top