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.