IF statement work working - help

[kroach123]

Does anyone know what I am doing wrong with this formula? IF(E5=1,(H5*I5)*G5,(H5*I5))

 

[Norie]

Looks fine to me, what's the problem?

PS There is a missing = at the start but I'm assuming that's a typo.

 

[Roxxien]

Hum, what is wrong with your result?

You give us what you are testing this on?

 

[Joe4]

Welcome to the Board!

Is E5 the number 1, or the text value 1?

If text, it would have to be:

[COLOR=#333333]=IF(E5="1",H5*I5*G5,H5*I5)[/COLOR]

 

[Jonmo1]

Well it's not 'Wrong' persay, but you don't need all the () on your multiplication operations.

It could just be
=IF(E5=1,H5*I5*G5,H5*I5)

Other than that (and the missing = at the beginning), there is nothing 'wrong' with the formula


Why don't you tell us what the symptoms are...
In what way is it not working for you?
Do you get an error? What error?
Do you get the wrong result? What result DO you get? And how is that different from what you expected?
What are the values of all the cells involved?

 

[FDibbins]

I also cant see anything "wrong" there, it could be simplified to this though...
=H5*I5*IF(E5=1,G5,1)