Reference 2

J

Jackie Morin

How do I have a cell look at another cell and make a calculation. For example:

A B C
(197) 3500 500

If column A is less than B then have the calculation of the amount of (C) it
would take to bring it to positive standing. The answer should be 4000. That
is (8) lots of 500 to make the amount 3803. That is C times (8) minus 197. If
(A) was 3501 then I would have a return value of 0. I would not need to
replenish.
 
T

tompl

Assuming your numbers are in cells A1 B1 and C1 then put this formula in cell
D1:

=IF(A1<B1,(ROUNDUP((B1-A1)/C1,0))*C1,0)

Tom
 
B

Bernard Liengme

Not sure I really understand the problem but does this help:
=IF(A1<B1,CEILING((B1-A1),500),0)
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference 3
Find the lowest number? 3
Row Calculation 1
sumif or sumproduct 3
Calculate percent of a total within a cell 4
Getting the correct SUM answer 1
Having a cell show X but read something else? 4
IF NEGATIVE VALUE REPLACE WITH POSITIVE 3

Top