Formula "if" Please Help

  • Thread starter Thread starter SUNNYBEE
  • Start date Start date
S

SUNNYBEE

Could you please let me know why the following formula doesn't work?

=if(PRODUCT(F12*F18)>=0,PRODUCT(F12*F18),0)

Thanks a lot

Sunny
:p
 
Sunnybee

The PRODUCT function shouldn't have an asterisk in it. It should be:
=IF(PRODUCT(F12,F18)>=0,PRODUCT(F12,F18),0)

Andy
 
I can see nothing functionally wrong with it. What does it do - i.e. what is
'not working'.
Do you have real numbers in the two cells?
You really do not need the PRODUCT function. You could use
=IF(F12*F18>0,F12*F18,0)
The PRODUCT function is more correctly used in the form PRODUCT(F12,F18) and
is redundant in the form you have it.

Without seeing the actual result is difficult to advice. If there is an
error result try =IF(ISERROR(F12*F18),0,F12*F18)

Bernard
 
Sunny,
The function PRODUCT(cell,cell) has to be separated by a
comma instead of the asterix sign.
 
Back
Top