How to Combine 2 Formulas in one box? Closed

Question

Hello, 
I would gladly appreciate any advice on how to finish or redo my formula. I have most of my formula but I can not figure out how to do the last part. 
here is what the  (60-A1)*0.00055 so I have that set up under =SUM((60-A1)*0.00055) 
Now I would like to add if A1 is less than 60 add 1 or greater than 60 minus 1. Then after Multiply B1.
Thank you in advanced :)


Configuration: Windows 7 / Mozilla 11.0

RayH · Answer

I don't think you need to use the SUM function here. Try this:

=((60-A1)*0.00055+((A1<60)-(A1>60)))*B1

How to Combine 2 Formulas in one box?

1 response

Subscribe To Our Newsletter!