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 Pete Your Own Question
Pete
Pete, Computer Enthusiast
Category: Computer
Satisfied Customers: 18113
Experience:  Over 16 years of experience in the Electronics and IT industries.
30970729
Type Your Computer Question Here...
Pete is online now

I am doing a spreadsheet for our business and working out costings

Resolved Question:

I am doing a spreadsheet for our business and working out costings depending on a m2 figure.
I'm wanting to be able to enter a m2 number and be able to calculate to cost of the job depending on that figure. However the formulas for some of the materials etc change depending on whether the number of m2 falls between certain ranges, for example if the figure was between 0-50m2 it would be the m2 figure * 0.4
51-100m2 it would be the m2 figure * 0.2 and so on. My question is how do I put that into a formula?
Kind regards
Submitted: 3 years ago.
Category: Computer
Expert:  Pete replied 3 years ago.
Hi there,
You can put the ranges into a formula using a Nested IF function.
For example:
=If(A2 < 50, .4, IF(A2 < 100,.2,if(A2 < 150,.1,if(A2 < 200,.05,if(A2 < 250,.01,0.005)))))
This will check the m2 number and if it is less than 50 it will return 0.4
If not less than 50, then if it is less than 100, it will return 0.2.
If not less than 100, then if it is less than 150, it will return 0.1.
... and so on.
Pete and other Computer Specialists are ready to help you