Formulas in Excel

[Chris]

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

 

[papou]

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

 

[JE McGimpsey]

One way:

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

for the CF:

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

 

[Chris]

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