I've got a series of numbers and I'd like to assign a value to a different cell.
A1 14
B1 12
C1 19
D1 27
I'd like to write (somewhere):
if (A1> B1)
E1 = E1 + 3
if (C1 > D1)
E1 = E1 + 4
so I'm constantly changing the value in E1 based on a comparison of numbers in other cells. Is there a way in Excel to do this?
Thanks.
J
A1 14
B1 12
C1 19
D1 27
I'd like to write (somewhere):
if (A1> B1)
E1 = E1 + 3
if (C1 > D1)
E1 = E1 + 4
so I'm constantly changing the value in E1 based on a comparison of numbers in other cells. Is there a way in Excel to do this?
Thanks.
J