Formula help

Question

I need a formula that will calculate a number in a specific cell up to $350.00.

For example, if I enter $230.00 into cell A1, I want B1 to calculate the difference up to 350$.

In other words, I want it to automatically figure out the difference is $120.00 and B1 will say $350.00 when I enter $230.00 into A1.

If nothing is in cell A1, I want B1 to be 0.

Thanks.

joeuser2004 · Answer

tascott75&nbsp;&nbsp;In B1:&nbsp;=IF(A1="", 0, MAX(0, 350-A1))&nbsp;&nbsp;

tascott75 · Answer

Thank you JoeUser2004! I tried the formula however it's putting into B1, the difference between A1 and B1.If I put 69.75 into A1, B1 will show 280.25, instead of 350.00.

jihad al-jarady · Answer

Yes, you said you want B1 to show the difference between A1 and 350!What exactly you want?

tascott75 · Answer

My apologies that I wasn't clear.I feel like there isn't actually a formula to calculate what I am looking for. Thank you for your help though!

joeuser2004 · Answer

&nbsp;tascott75&nbsp; wrote:&nbsp; ``My apologies that I wasn't clear.&nbsp; I feel like there isn't actually a formula to calculate what I am looking for.``&nbsp;&nbsp;Don't give up on us so quickly.&nbsp;Originally, you wrote:&nbsp; ``[the formula will] figure out the difference is $120.00 and B1 will say $350.00 when I enter $230.00 into A1.``&nbsp;So, it is indeed clear that B1 is __not__ the difference between A1 and 350.&nbsp; My bad!&nbsp;You provided an example where A1 is less than 350.&nbsp; What should B1 return if A1 exceeds 350?&nbsp;Perhaps you want the following in B1:&nbsp;=IF(A1="", "", MAX(350, A1))

Forum Discussion

Formula help

7 Replies

Resources