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