Hi

Try this:
=IF(I26=2,G6*J29,"")

The format for an IF formula is:
=IF(criteria , answer if TRUE , answer if FALSE)

Hope this helps.
Andy.

"JOSIL" wrote in
message ...

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