=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