Formulas in Excel
 

Hi Guys,

Can you help me with a formula in Excel. I am trying to compare the data
from 2 different cells and based on the outcome post a result in another
cell. I've written an example of the argument below but cannot seem to get
the syntax to work:

If Cell F7 = N
and Cell M7 = 1
then Cell O7 = 3 (would be even better if I could make the cell go red
automatically but I think I can do this with Conditional formatting)

Any help appreciated

Chris

Formulas in Excel
 

Hello

In cell O7:
1-Formula :
=IF(AND(F7="N",M7=1),3,"")

2-Format, Conditional Formatting
In Condition 1 select: Formula is:
=AND(F7="N",M7=1)

HTH
Cordially
Pascal
"Chris" a écrit dans le message de news:
...
Hi Guys,

Can you help me with a formula in Excel. I am trying to compare the data
from 2 different cells and based on the outcome post a result in another
cell. I've written an example of the argument below but cannot seem to get
the syntax to work:

If Cell F7 = N
and Cell M7 = 1
then Cell O7 = 3 (would be even better if I could make the cell go red
automatically but I think I can do this with Conditional formatting)

Any help appreciated

Chris

Formulas in Excel
 

One way:

O7: =IF(AND(F7="N",M7=1),3,"")

for the CF:

CF1: Formula is =AND(F7="N",M7=1)
Format1: <patterns/<red


In article ,
Chris wrote:

Hi Guys,

Can you help me with a formula in Excel. I am trying to compare the data
from 2 different cells and based on the outcome post a result in another
cell. I've written an example of the argument below but cannot seem to get
the syntax to work:

If Cell F7 = N
and Cell M7 = 1
then Cell O7 = 3 (would be even better if I could make the cell go red
automatically but I think I can do this with Conditional formatting)

Any help appreciated

Chris

Formulas in Excel
 

Papau,

Many thanks worked a treat, so how would I get the cell to change to Amber &
Green if the following conditions where met:

If Cell F7 = Y
then Cell O7 = 1 or green

Any other condition for cells F7 & M7 then cell FO7 = amber


"papou" wrote:

Hello

In cell O7:
1-Formula :
=IF(AND(F7="N",M7=1),3,"")

2-Format, Conditional Formatting
In Condition 1 select: Formula is:
=AND(F7="N",M7=1)

HTH
Cordially
Pascal
"Chris" a écrit dans le message de news:
...
Hi Guys,

Can you help me with a formula in Excel. I am trying to compare the data
from 2 different cells and based on the outcome post a result in another
cell. I've written an example of the argument below but cannot seem to get
the syntax to work:

If Cell F7 = N
and Cell M7 = 1
then Cell O7 = 3 (would be even better if I could make the cell go red
automatically but I think I can do this with Conditional formatting)

Any help appreciated

Chris