| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 IF THEN STATEMENTS TOGETHER IN ONE FORMULA
Hi -
I'm having trouble figuring out the following formula If F6 = b and If G6= b then put N otherwise put P BUT if F6= n and G6 = n put N otherwise put P. Does that make sense - having trouble with the double if then statement - what do I put in between to connect them. I keep gettting an error... thanks A |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
2 IF THEN STATEMENTS TOGETHER IN ONE FORMULA
Nevermind - I'm an idiot.
A wrote: Hi - I'm having trouble figuring out the following formula If F6 = b and If G6= b then put N otherwise put P BUT if F6= n and G6 = n put N otherwise put P. Does that make sense - having trouble with the double if then statement - what do I put in between to connect them. I keep gettting an error... thanks A |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
2 IF THEN STATEMENTS TOGETHER IN ONE FORMULA
OK - I'm wrong again... I still can't get it to work. I thought this
would work but it didn't =IF(F6="b",IF(G6="b","N", IF(F6="b",IF(G6="n","N"), IF(F6="n",IF(G6="n","N",IF(F6="n",IF(G6=b,P))))))) ) The first 2 sets of IFs work (The first 4 IF Statements) which is why I thought it worked, but if I change column F6 to n, it returns a FALSE. Any help would be greatly appreciated. Thanks A A wrote: Nevermind - I'm an idiot. A wrote: Hi - I'm having trouble figuring out the following formula If F6 = b and If G6= b then put N otherwise put P BUT if F6= n and G6 = n put N otherwise put P. Does that make sense - having trouble with the double if then statement - what do I put in between to connect them. I keep gettting an error... thanks A |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
2 IF THEN STATEMENTS TOGETHER IN ONE FORMULA
=if(and(F6="b",G6="b"), "N", if(and(F6="n",G6="n"), "N", "P"))
or something like that Tim "A" wrote in message oups.com... Hi - I'm having trouble figuring out the following formula If F6 = b and If G6= b then put N otherwise put P BUT if F6= n and G6 = n put N otherwise put P. Does that make sense - having trouble with the double if then statement - what do I put in between to connect them. I keep gettting an error... thanks A |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
2 IF THEN STATEMENTS TOGETHER IN ONE FORMULA
Thanks - I figured out in a round about way by having it return two
columns, one of which all says false and then another IF statement to pick whichever column is not false. Not the best but it works Tim Williams wrote: =if(and(F6="b",G6="b"), "N", if(and(F6="n",G6="n"), "N", "P")) or something like that Tim "A" wrote in message oups.com... Hi - I'm having trouble figuring out the following formula If F6 = b and If G6= b then put N otherwise put P BUT if F6= n and G6 = n put N otherwise put P. Does that make sense - having trouble with the double if then statement - what do I put in between to connect them. I keep gettting an error... thanks A |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can i run 2 IF statements in one formula? | Excel Worksheet Functions | |||
| Fiveif statements in a formula | Excel Worksheet Functions | |||
| HOW MANY IF STATEMENTS CAN YOU HAVE IN ONE FORMULA? | Excel Discussion (Misc queries) | |||
| If, Then statements with a formula | Excel Discussion (Misc queries) | |||
| IF statements/formula problem | Excel Worksheet Functions | |||
![A[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
