Perhaps this may suffice:
=IF(H16="","",H16*N16*IF(R160,R16,1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Frances C" wrote:
I am using this formula =IF(COUNT(H16,N16)=2,H16*N16*IF(R160,R16,1),"")
and works fine, It does not shows in the cell if I have not enter a number
in H16.

But If I enter zero in H16 the formula does not calculates. Can you help me
with that.