Forum Discussion
Formula help
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))
JoeUser2004 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!
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. (!)