Is there any way to make this Last line end result equal 0 dollars..
D= " a number i change to make last line = amount i need " but sometimes
it is not used so i want to put in a number like 100 and make it equal 0
dollars
my first line is
E12=D12*200+SUM(D12)
2nd line
F12=1000/E12
Last line
K12=CEILING(D28/K3+K35,0.05)

Thanks All. If have been trying to figure this one out for a long time

What's the relationship between last line and lines 1 & 2?

E12=D12*200+SUM(D12)
is same as ....
E12=D12*201

Very confused!

"Chev320" wrote:

Is there any way to make this Last line end result equal 0 dollars..
D= " a number i change to make last line = amount i need " but sometimes
it is not used so i want to put in a number like 100 and make it equal 0
dollars
my first line is
E12=D12*200+SUM(D12)
2nd line
F12=1000/E12
Last line
K12=CEILING(D28/K3+K35,0.05)

Thanks All. If have been trying to figure this one out for a long time