In D19 enter this
=IF(C19<>"",C19*D11,"")
alternatively
=IF(C19="","",C19*D11)
Thanks all for the help. I would like a cell D19 to calculate a formula ONLY if cell C19 produces a number, otherwise I would like it to remain clear. I would like cell D19's formula to calculate =C19*D11. How can I do this?
In D19 enter this
=IF(C19<>"",C19*D11,"")
alternatively
=IF(C19="","",C19*D11)
Last edited by bryce; September 15th, 2006 at 09:43.
=if(isnumber(c19),c19*d11,"")
There are currently 3 users browsing this thread. (0 members and 3 guests)
Bookmarks