**Question description:**

*This user has given permission to use the problem statement for this
blog.*

Hello,
I need to do a calculation in excel
If cell e2 <5 then f2=500
If cell e2=5 but is <10 then f2=1000
If cell e2=10 but is less than 15 then f2=1500
If cell e2+>16 then f2=2000

Solved by E. F. in 29 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

User
16/05/2018 - 01:25

Hello

Excelchat Expert
16/05/2018 - 01:25

Hi welcome

User
16/05/2018 - 01:26

I need a formula that does the following:

Excelchat Expert
16/05/2018 - 01:26

will you be sharing any data on which to do the required calculations?

User
16/05/2018 - 01:26

no

User
16/05/2018 - 01:27

I just need an example formula

Excelchat Expert
16/05/2018 - 01:27

ok

Excelchat Expert
16/05/2018 - 01:27

so these are the conditions?

Excelchat Expert
16/05/2018 - 01:27

Hello, I need to do a calculation in excel If cell e2 <5 then f2=500 If cell e2=5 but is <10 then f2=1000 If cell e2=10 but is less than 15 then f2=1500 If cell e2+>16 then f2=2000Hello, I need to do a calculation in excel If cell e2 <5 then f2=500 If cell e2=5 but is <10 then f2=1000 If cell e2=10 but is less than 15 then f2=1500 If cell e2+>16 then f2=2000

User
16/05/2018 - 01:28

Those are them!

Excelchat Expert
16/05/2018 - 01:28

ok, please give me a few minutes while i formulate this

User
16/05/2018 - 01:28

the last one should be if cell e2=>16, f2=2000

Excelchat Expert
16/05/2018 - 01:28

ok

Excelchat Expert
16/05/2018 - 01:28

noted

Excelchat Expert
16/05/2018 - 01:40

5

User
16/05/2018 - 01:40

what?

Excelchat Expert
16/05/2018 - 01:41

no no sorry

Excelchat Expert
16/05/2018 - 01:41

i was typing in excel

Excelchat Expert
16/05/2018 - 01:41

it mistakenly typed in chat

User
16/05/2018 - 01:41

LOL ok

Excelchat Expert
16/05/2018 - 01:41

:)

Excelchat Expert
16/05/2018 - 01:41

6

Excelchat Expert
16/05/2018 - 01:41

lol

Excelchat Expert
16/05/2018 - 01:42

i think you are also clicking the sheet

User
16/05/2018 - 01:42

sorry, I'm not sure what that means

Excelchat Expert
16/05/2018 - 01:43

no problem near completion

User
16/05/2018 - 01:44

One would think this would have been a basic formula but gosh darn it I could only get it for one value

Excelchat Expert
16/05/2018 - 01:45

one clarification

User
16/05/2018 - 01:45

sure

Excelchat Expert
16/05/2018 - 01:45

what if e2=15/

Excelchat Expert
16/05/2018 - 01:45

?

User
16/05/2018 - 01:46

1-4=500, 5-9=1000, 10-14=1500, 15+=2000

User
16/05/2018 - 01:47

so it should have been >=15 not 16. Good catch!

Excelchat Expert
16/05/2018 - 01:47

thank you

User
16/05/2018 - 01:47

Thank you

Excelchat Expert
16/05/2018 - 01:53

Done.

Excelchat Expert
16/05/2018 - 01:53

Please check cell F2

User
16/05/2018 - 01:54

Wonderful! Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!

Excelchat Expert
16/05/2018 - 01:54

You are welcome. Happy to help you Dear.

Excelchat Expert
16/05/2018 - 01:54

Have a good day.

User
16/05/2018 - 01:54

Same to you!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*