You do not need the "THEN" - amend as follows:

=IF (I26 = 1, G6*J29 )

You have not specified what you want to happen if I26 is not equal to
1.

Hope this helps.

Pete

JOSIL wrote:
Why the following excel formula keep giving me an error?

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


--
JOSIL
------------------------------------------------------------------------
JOSIL's Profile: http://www.excelforum.com/member.php...o&userid=37175
View this thread: http://www.excelforum.com/showthread...hreadid=568918