**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.*