Simple Excel Query

[Linden Lewis]

Should be a simple solution for someone:

I am calculating a spreadsheet to work out total costs. I have one cost, variable on the amount of instructors I employ.

1-3 instructors = $130
4-6 Instructors = $150
7+ = $130

The number of instructors will be in Excel cell A1 so I need to express the below statement as an excel formula.

=130 if A1 (i.e. the number of instructors) is less that 4, but 150 if A1 is less than 7, and $130 if A1 is greater than 7

Thanks for the help!

 

[AndrewEardley]

It will be something like

=if(A1<4,130,if(A1<7,150,130))

 

[Linden Lewis]

I have actually beenable to solve it:

=IF(A1<4,170,IF(a1<7,150,IF(a1>7,130)))

 

[Scalloway]

Or

=IF(AND(A1>3,A1<7),150,130)

 

[AndrewEardley]

Or

=IF(AND(A1>3,A1<7),150,130)

Never seen that before but if id have know that would have saved myself so much typing in the past!!

 

[AndrewEardley]

Or

=IF(AND(A1>3,A1<7),150,130)

Would it not be =IF(AND(A1>3,A1<6),150,130) ??

 

[Scalloway]

It works for me the way I set it up. If I type 7 in A1 I get 130.

 

[AndrewEardley]

My apologies, I was reading it wrong!

I don't have excel in front of me