Prev: Sum of Highlighted values
Next: Deleting Worksheet in excel = 2003 / 2007
From: Sunflower on 24 Jan 2010 14:05
How do I combine two IF statements?

=IF(C12="PTO",-8,C12*$E$3)

OR

=IF(C12="HOLIDAY",0,C12*$E$3)



Thanks for any and all help
From: Joe User on 24 Jan 2010 14:20
"Sunflower" <luvsunflowers(a)gmail.com> wrote:
> How do I combine two IF statements?
> =IF(C12="PTO",-8,C12*$E$3)
> OR
> =IF(C12="HOLIDAY",0,C12*$E$3)

Perhaps:

=IF(C12="PTO", -8, IF(C12="HOLIDAY", 0, C12*$E$3))
From: Sunflower on 24 Jan 2010 14:37
On Jan 24, 11:20 am, "Joe User" <joeu2004> wrote:
> "Sunflower" <luvsunflow...(a)gmail.com> wrote:
> > How do I combine two IF statements?
> > =IF(C12="PTO",-8,C12*$E$3)
> > OR
> > =IF(C12="HOLIDAY",0,C12*$E$3)
>
> Perhaps:
>
> =IF(C12="PTO", -8, IF(C12="HOLIDAY", 0, C12*$E$3))

Thanks...works
From: Mike H on 24 Jan 2010 14:59
Hi,

=IF(C12="PTO",-8,IF(C12="Holiday",0,C12*$E$3))

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sunflower" wrote:

> How do I combine two IF statements?
>
> =IF(C12="PTO",-8,C12*$E$3)
>
> OR
>
> =IF(C12="HOLIDAY",0,C12*$E$3)
>
>
>
> Thanks for any and all help
> .
>
 | 
Pages: 1
Prev: Sum of Highlighted values
Next: Deleting Worksheet in excel = 2003 / 2007