=50-(C2=2)-(C22)

Think you're missing some stuff the

=50-(C2=2)*25-(C22)*50

And to account for an empty cell:

=(50-(C2=2)*25-(C22)*50)*(C2<"")

Biff

"Arvi Laanemets" wrote in message
...
Hi

Replace your formula with
=IF(C2<2,50,IF(C2=2,25,IF(C23,0)))

But what about 3=C22

Btw. you can do without any IF's (slightly different conditions in my
example here)

=50-(C2=2)-(C22)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"David" wrote in message
...
I want to SUM a horizontal row of cells, of which one contains the IF
function:
=IF(C2<2,"50",IF(C2=2,"25",IF(C23,"0")))

I want the results of the IF function, 50, 25, or 0, to be included in
the
SUM.
Any tips?