Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi Can you see any glaring error with the below formula and help me why it wont work? =IF(E8<400,J6,(IF(E8<=1200,J5)),(IF(E8>=1201,J4)))*E8 Thanks Em
Solved by V. C. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 02/04/2018 - 12:52
Hi - do you need more informaiton?
Excelchat Expert 02/04/2018 - 12:52
Hello, good day! Let me check your IF syntax for a while to identify the reason(s) why it wont work
User 02/04/2018 - 12:52
ok thanks
User 02/04/2018 - 12:52
can i paste data in the cells to help you?
Excelchat Expert 02/04/2018 - 12:53
May i confirm if you could see the preview on edit i'm trying to work out?
User 02/04/2018 - 12:53
yes i can
Excelchat Expert 02/04/2018 - 12:53
Yes, kindly try populating the target cells to see if your intention for the formula is working
Excelchat Expert 02/04/2018 - 12:54
can you please populate cell J4 as well?
User 02/04/2018 - 12:55
just spotted that
User 02/04/2018 - 12:55
it's a tax calc
Excelchat Expert 02/04/2018 - 12:56
okay, got it. I am an accountant too. so where do you intend the IF formula to be placed, by the way?
User 02/04/2018 - 12:56
F8
User 02/04/2018 - 12:56
and thanks that's v cool
User 02/04/2018 - 12:56
i can't see the formulas how did you do that?
Excelchat Expert 02/04/2018 - 12:57
please see cell F8
User 02/04/2018 - 12:57
OMG what did I miss?
User 02/04/2018 - 12:57
and thank you
Excelchat Expert 02/04/2018 - 12:57
when you work with multiple conditions for an IF formula
User 02/04/2018 - 12:58
yes
Excelchat Expert 02/04/2018 - 12:58
for example =IF(E8<400 <--- this is your first condition
User 02/04/2018 - 12:58
yes
Excelchat Expert 02/04/2018 - 12:59
then it should be followed by the result if the condition is met
User 02/04/2018 - 12:59
yes and i had that
Excelchat Expert 02/04/2018 - 12:59
thus continuing it to =IF(E8<400, J6
Excelchat Expert 02/04/2018 - 12:59
the when the condition is not met, you begin again with another set of condition
User 02/04/2018 - 01:00
ok so just the comma is enough
Excelchat Expert 02/04/2018 - 01:00
but where you got it wrong is you begin it with a parenthesis
User 02/04/2018 - 01:00
which is?
Excelchat Expert 02/04/2018 - 01:00
yes, a comma then the next IF statement
User 02/04/2018 - 01:00
it kept saying that error
Excelchat Expert 02/04/2018 - 01:00
for purpose of comparison that is
Excelchat Expert 02/04/2018 - 01:01
=IF(E8<400,J6,(IF(E8
Excelchat Expert 02/04/2018 - 01:01
which will return an error
Excelchat Expert 02/04/2018 - 01:01
vs =IF(E8<400,J6,IF(E8
User 02/04/2018 - 01:01
ok so no bracket?
User 02/04/2018 - 01:01
not ,(IF just ,IF
Excelchat Expert 02/04/2018 - 01:01
yes, correct, no need for a bracket / parenthesis
User 02/04/2018 - 01:01
ok
Excelchat Expert 02/04/2018 - 01:01
yes
Excelchat Expert 02/04/2018 - 01:02
well I hope that solves your problem :)
User 02/04/2018 - 01:02
i think, I did try that earlier, but had too many brackets at the end and then just kept trying and got myself ocnfused
User 02/04/2018 - 01:02
yes indeed!!
Excelchat Expert 02/04/2018 - 01:02
a tip
User 02/04/2018 - 01:02
Thanks - now I can sleep! lol
User 02/04/2018 - 01:02
yes sure
Excelchat Expert 02/04/2018 - 01:03
usually when you type a closing bracket to your IF statements, it will highlight the nearest closest opening bracket
User 02/04/2018 - 01:03
yes and I was looking at them - had four colours on the go
User 02/04/2018 - 01:04
but couldn't see it
Excelchat Expert 02/04/2018 - 01:04
try opening the formula on cell f8
User 02/04/2018 - 01:04
and that's when I started moving brackets and clearly messed it up
User 02/04/2018 - 01:04
makes sense, that ,IF is the FALSE
User 02/04/2018 - 01:04
and continues on
Excelchat Expert 02/04/2018 - 01:05
do you notice than when you highlight the closing bracket next to ...,J4 it shows that the closing bracket corresponds to an opening bracket on your ...IF(E8...etc.
Excelchat Expert 02/04/2018 - 01:05
can you follow my explanation?
User 02/04/2018 - 01:06
sorry - closed the browser by accidnet - but i'm back and yes - that makes sense
Excelchat Expert 02/04/2018 - 01:07
so you can see where each of the four closing bracket after ...J4 in your formula pertains to
User 02/04/2018 - 01:07
now i need to make J4, J5 and J6 absolute to copy down and i'mgood
User 02/04/2018 - 01:07
yep
Excelchat Expert 02/04/2018 - 01:07
yup :)
User 02/04/2018 - 01:07
getting there......
User 02/04/2018 - 01:07
then create a macro before I can sleep :(
Excelchat Expert 02/04/2018 - 01:08
Glad to be of help to you. Good luck on your work :)
User 02/04/2018 - 01:08
thanks - I might be back..... but hopefully noy
User 02/04/2018 - 01:08
service is awesome - thanks
Excelchat Expert 02/04/2018 - 01:09
You're welcome. I am now closing this session. Do you have the copy of the corrected formula already?
User 02/04/2018 - 01:09
yes - and updated with absolute and saved!
User 02/04/2018 - 01:09
nks
User 02/04/2018 - 01:09
thanks
Excelchat Expert 02/04/2018 - 01:10
Alright. You're welcome again. Good bye :)
Excelchat Expert 02/04/2018 - 01:21
hi, if you are there another tip to make it easier to review your multiple IF formula... you can press ALT+Enter on your next IF(... such that it will be the same with the one on cell F8

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.