Feb 04 2022 11:56 AM
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.
Feb 04 2022 01:07 PM
Feb 04 2022 01:19 PM
Feb 04 2022 01:32 PM
Feb 04 2022 02:22 PM
@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))
Feb 04 2022 02:45 PM - edited Feb 04 2022 02:47 PM
@Joe User Well, you have proven me wrong! That was exactly the right formula and what I needed to show in the cell! (And A1 would never exceed 350 for my purposes.) I really appreciate the help, I'm sorry for giving up so quickly. Thanks so much, problem solved!
Feb 04 2022 07:39 PM - edited Feb 04 2022 07:44 PM
@tascott75 wrote: ``And A1 would never exceed 350 for my purposes.``
Huh?! Then perhaps all you need in B1 is:
=IF(A1="", "", 350)
In my previous response, MAX(350, A1) returns 350 whenever A1 is less, and it returns A1 whenever it is more than 350. But if A1 "never exceeds 350", MAX(350, A1) always returns 350. (!)