# Need a calculation formula

#### calmedic21

##### New Member
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!

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### lenze

##### Legend
Since A16 will be a number, for B16 you can use,
Code:
``=If(A16,A16+105.00,"")``
For C16, use
Code:
``=If(A16,B16*.42,"")``
Similar for D:E

lenze

#### calmedic21

##### New Member
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

Replies
3
Views
36
Replies
2
Views
52
Replies
4
Views
131
Replies
3
Views
264
Replies
52
Views
754

1,127,334
Messages
5,624,089
Members
416,010
Latest member
NJT

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back