|
Calculations
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 |
Calculations
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 |
| All times are GMT +1. The time now is 12:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com