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" 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" wrote:> "Sunflower" 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 valuesNext: Deleting Worksheet in excel = 2003 / 2007