Need a calculation formula

[calmedic21]

Here is the info on what I need help on.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
A16 = List Price<o></o>
B16 = List Price +$105.00<o></o>
C16 = Total of B16 * .42<o></o>
D16 = Total of B16 * .46<o></o>
E16 = Total of B16 * .50<o></o>
<o> </o>
The only thing is I need cells B16 - E16 to read $0.00 if there is nothing in Cell A16.

Thanks Guys!

 

[lenze]

Since A16 will be a number, for B16 you can use,

=If(A16,A16+105.00,"")

For C16, use

=If(A16,B16*.42,"")

Similar for D:E

lenze

 

[calmedic21]

Hello Lenze....

Thank you for the formula. It works but when I delete the List Price, all the other cells go blank as well. Is there a way to show $0.00 when A16 is empty?

Thanks