Forum Discussion
Formula help
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 wan...
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.
If I put 69.75 into A1, B1 will show 280.25, instead of 350.00.
- Yes, you said you want B1 to show the difference between A1 and 350!
What exactly you want?- 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!tascott75 wrote: ``My apologies that I wasn't clear. I feel like there isn't actually a formula to calculate what I am looking for.``
Don't give up on us so quickly.
Originally, you wrote: ``[the formula will] figure out the difference is $120.00 and B1 will say $350.00 when I enter $230.00 into A1.``
So, it is indeed clear that B1 is __not__ the difference between A1 and 350. My bad!
You provided an example where A1 is less than 350. What should B1 return if A1 exceeds 350?
Perhaps you want the following in B1:
=IF(A1="", "", MAX(350, A1))
