"If" function

josil · August 7th, 2006, 04:41 AM

Why the following excel formula keep giving me an error?

=IF (I26 = 1, THEN (G6*J29))

jrogers · August 7th, 2006, 05:46 AM

change to

Code:

=if(I26=1,(G6*J29),0)

You dont need the 'Then' statement

josil · August 7th, 2006, 06:18 AM

Nop.

I tried as well even this:

=if(I26=1,G6*J29,if(I26=2,g6*K29,if(I26=3,g6*L29)) )

and

=INDEX(J29:Z29,I26)*G6

Still gives an error

josil · August 7th, 2006, 06:30 AM

My friend

I found the reason that gives errors.
My excell is in Portuguese and the statement must be like this:

=SE(K26=1;$G6*$J29;SE(K26=2;$G6*K29;SE(K26=3;$G6*L 29))*0)

SE mean IF and have to use ; instead of ,

Just remember this for future.

Thanks a lot.