44 | 49 |
31 | 21 |
22 | 44 |
23 | 21 |
33 | 46 |
48 | 21 |
43 | 34 |
21 | 44 |
25 | 40 |
20 | 34 |
<tbody>
</tbody>
I have my data as shown above in column A & B respectively. I want a formula to be put "C1". if any of the value in column B1:B10 is greater than Column A1:A10 respectively then it should return as "Greater". (for e.g. if B1>A1 or B2>A2, and so on. Also, for A11 to A15 I am using the sum amount to compare as shown in bold in below formula. Currently I am using the below formula which becomes very big if applied for 10 rows. Please help with a better formula.
=IF(OR(B1>A1,B2>A2,B3>A3,B4>A4,B5>A5,B6>A6,B7>A7,B8>A8,B9>A9,B10>A10,SUM(B11:B15)>SUM(A11:A15)),"Greater","Perfect")
Last edited: