"Frances C" wrote
it does not work, it gives me a false

Perhaps this may suffice:
=IF(H16="","",H16*N16*IF(R160,R16,1))

I don't know how the suggested alternative could have possibly returned
FALSE over there.

It either returns zero if you input a zero in H16 where N16/R16 is either
blank or contain numbers.

Or it returns an error: #VALUE! if N16 or R16 contains text instead of
number(s).

If H16 is blank, it'll simply return a blank: ""
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---