• 100% Satisfaction Guarantee

Pete, Computer Enthusiast
Category: Computer
Satisfied Customers: 16318
Experience:  Over 16 years of experience in the Electronics and IT industries.
30970729
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: 2 years ago.
Category: Computer
Expert:  Pete replied 2 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, Computer Enthusiast
Category: Computer
Satisfied Customers: 16318
Experience: Over 16 years of experience in the Electronics and IT industries.

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.

• ### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >

### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

### James K.

#### Satisfied Customers:

93
Technical Director of IT Company

### Jon-Tech

#### Satisfied Customers:

61
20 yrs: Computers, Networking

### MikeW

#### Satisfied Customers:

53
32+ years Computer and Networking Experience

### jamieratliff

#### Satisfied Customers:

21
Jamie has worked in the Information Technology field for over a decade.

### TheDoctor

#### Satisfied Customers:

16
Experienced Software Engineer