![]() |
Anyone know how
To convert a number in excel to another number... being specific I would like to do the following :
if h2 = 1 then I would like to convert that to 100 if h2 = 2 then I would like to convert that to 80 if h2 = 3 then I would like to convert that to 60 if h2 = 4 then I would like to convert that to 40 if h2 = 5 then I would like to convert that to 20 if h2 is greater than 5 I would like to convert that to 0 I am sure there is a way to do it but I am ************ed if I can... |
1 Attachment(s)
XPT,
Had a play with excel for you - here is what you asked for. Hope it is what you want. ![]() |
Gday iamcool
thanks alot for that.. that gave me what i wanted and also an idea of how to write my own IF formulae... thanks again |
Another way to skin this cat would be :-
=IF(H2>5,0,120-H2*20) Wun |
All times are GMT +10. The time now is 11:40 AM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.