View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default SUM and IF results

Arvi!
Thanks, I love the simple solutions.
David

"Arvi Laanemets" wrote:

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?