How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1920
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

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

This answer was rated:

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)

Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

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: 1920
Experience: 20 years experience providing remote computer support
The-PC-Guy and other Microsoft Office Specialists are ready to help you

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

Related Microsoft Office Questions