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.