Forum Discussion

tascott75's avatar
tascott75
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...
excel
Formulas and Functions
JoeUser2004's avatar
JoeUser2004
Bronze Contributor
Feb 04, 2022

tascott75 

 

In B1:

 

=IF(A1="", 0, MAX(0, 350-A1))

 

 

  • tascott75's avatar
    tascott75
    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's avatar
      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's avatar
        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!

Resources