One column to another
Hi
Perhaps you could use
=ABS(C13-44)
--
Regards
Roger Govier
Make one column equal to another number wrote:
I am looking to make a number equal from one cell to another number. EX:
43=1, 42=2, 41=3, etc. going 43 to 1. here is how i have done it so far:
=IF(C13=43,"1",IF(C13=42,"2",
IF(C13=41,"3",IF(C13=40,"4",IF(C13=39,"5",IF(C13=3 8,"6",
IF(C13=37,"7",IF(C13=36,"8")))))))) I have used 6 cells to complete it and I
know that is not the best way to do it.
|