| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with and OR
Can anyone help I trying to get a OR statement to work with and if
statement... what I am trying to do is if cell K8 is = 2 and P8 is =1 mark cell j8 with a win else not, what I am also trying to do is say in the same statement if K8 =1 and P8 =2 then mark cell j8 with win else not... =IF(AND(K8=2,P8=1),"Win","Not") can anyone help... Paul |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF with and OR
maybe
=IF(OR(AND(K8=2,P8=1),AND(K8=1,P8=2)),"Win","N ot") Mike "PR" wrote: Can anyone help I trying to get a OR statement to work with and if statement... what I am trying to do is if cell K8 is = 2 and P8 is =1 mark cell j8 with a win else not, what I am also trying to do is say in the same statement if K8 =1 and P8 =2 then mark cell j8 with win else not... =IF(AND(K8=2,P8=1),"Win","Not") can anyone help... Paul |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF with and OR
thanks very much, thats great... it is where you put the OR...
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
![PR[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
