# Excel - IF Function Problem - Expert Solution

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
User 16/05/2018 - 01:54
Wonderful! Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!
Excelchat Expert 16/05/2018 - 01:54
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.