G
Guest
I have the following in cells
D3: -2.5 -111
D4: +2.5 +101
D5: +10.5 -114
D6: -10.5 +104
D7: -8 +100
D8: +8 -110
Is there a formula I can enter into cell H3 that will give me just -2.5?
Note that all the cells aren't necessarily in the same format (some are X.5
and some are X). Thanks
D3: -2.5 -111
D4: +2.5 +101
D5: +10.5 -114
D6: -10.5 +104
D7: -8 +100
D8: +8 -110
Is there a formula I can enter into cell H3 that will give me just -2.5?
Note that all the cells aren't necessarily in the same format (some are X.5
and some are X). Thanks