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...
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. (!)