Forum Discussion

Copper Contributor

Feb 04, 2022

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...

Formulas and Functions

Copper Contributor

Feb 04, 2022

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

MCT

Feb 04, 2022

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

tascott75
Copper Contributor
Feb 04, 2022
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
  Bronze Contributor
  Feb 04, 2022
  
  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))
  - tascott75
    Copper Contributor
    Feb 04, 2022
    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!

Resources