• 100% Satisfaction Guarantee
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1960
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now

# I am trying to figure out how to write a formula that basically

I am trying to figure out how to write a formula that basically says "If cell B6 is equal to or greater than 80, subtract 80. I got that far. I can't figure out how to say if it equals 80 twice (or 160) subtract 160.

JBryan42 :

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.

JBryan42 :

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?

Customer:

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

Customer:

t get it to do is subtract if 80 is reached more than once (the number will never be more than 200)

try

=IF(AND(A6>80,A6<160),A6-80,IF(A6>=160,A6-160,A6))

let me know if you need anything else
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1960
Experience: 20 years experience providing remote computer support

Hi there.

The correct formula you need is as follows

=IF(AND(B6>80,B6<160),B6-80,IF(B6>=160,B6-160,B6))

If you have any difficulties, please do not hesitate to let me know

Thank you