I want to create a conditional formula that adds a specific value...

[mbxs3]

I have an E-Z pass for going through toll booths where I live. I like to keep track of how much the tolls are costing me each month on an excel spreadsheet. I have a cell set up that lets me know the total amount left on my E-Z pass balance by subtracting the sum of the amount I have spent from my initial E-Z pass balance. For my situation, my original balance was $35. So my formula for that "total" cell is very simple...it is just 35-sum.

My issue is that when my E-Z pass balance reaches $10 or less, it automatically recharges for $35. So I would like my excel spreadsheet to realize that my balance has reached <=10 and I want 35 added to that so that my E-Z pass balance is accurately reflected on my spreadhsheet. What formula would allow me to do this?

[FDibbins]

thats a little hard to say, without seeing you're data/layout etc. assuming you keep a running total in, say column C, then you could use a formula that looks at the total above to check for the $10 and then adds 35. something like...

in C10 =if(C9-B10<=10,C9-B10+35,C9-B10)
where B10 is todays expense

If that doesnt work for you, I would suggest that you upload a sample workbook, showing what data you are working with, what you're expected outcome is, and how you arrived at that

[mbxs3]

FDibbins-

Thanks so much for your input. It provided the information I needed to make my formula work the way I wanted it to.

I ended up just doing my formula like this (L2 is the cell that contains the amount I have paid in tolls):

=if(35-L2<=10, 35-L2+10, 35-L2)

I threw some numbers in my workbook to create the situation where the balance equaled 10, less than 10 and greater than 10 and it responded correctly, so I think I am good to go!

Thanks again!

[FDibbins]

Happy to help, and thanks for ther rep