Microsoft Office Questions? Ask a IT Expert for Support ASAP
Welcome to JustAnswer. My name is XXXXX XXXXX I will be assisting you today. Please do not rate this session until it has been completed.
Are you trying to get the cell to always be less than 80? So, if it starts off at 245 would it end up as 5?
I'm trying to get it to subtract 80 anytime its higher than that ... which I can Do with =IF(A6>=80,A6-80,A6), what I can
t get it to do is subtract if 80 is reached more than once (the number will never be more than 200)
The correct formula you need is as follows
If you have any difficulties, please do not hesitate to let me know