CODEWITHSUNDEEP
excelif-statementcompareexcel-formulaworksheet-function
Frits De Bruin
Frits De Bruin

Reputation: 11

Compare two cells and place the result in a third

I would like to compare in Excel two fields per column and place a flag in a third field:

If the table looks like:

+---+--------+----------+---+
|   |   A    |    B     | C |
+---+--------+----------+---+
| 1 | 100,00 | 100,00   |   |
| 2 | 100,00 | 50,00    |   |
| 3 | 100,00 | 200,00   | x |
+---+--------+----------+---+

If B is twice the value of A then C should get a flag.

How should I do this?

Upvotes: 0

Views: 134

Answers (1)

pnuts
pnuts

Reputation: 59485

Please try, in C1 and copied down to suit: 

=IF(B1=A1*2,"x","")

Upvotes: 1

Related Questions