Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
"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)) PS: In the future, post to only one NG, or crosspost. |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
On Jan 24, 11:22*am, "Joe User" <joeu2004 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)) PS: *In the future, post to only one NG, or crosspost. Thanks Sorry for the double posting... I am not sure how to "crosspost", However in the future I will not post to more than one group |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining 2 IF statements | Excel Discussion (Misc queries) | |||
If Statements & Combining Cells | Excel Worksheet Functions | |||
Combining IF Statements | Excel Worksheet Functions | |||
Combining IF statements | Excel Worksheet Functions | |||
combining conditional statements | Excel Worksheet Functions |