C Confused Feb 15, 2010 #1 What function do you use to get the value of one cell to be 50 for every 1000 value of another cell?
E Eva Feb 15, 2010 #2 I am notsure if this is what you mean try this =if(a1=1000,50,"") Click yes if helped
G Glenn Feb 15, 2010 #3 Confused said: What function do you use to get the value of one cell to be 50 for every 1000 value of another cell? Click to expand... =A1/20
Confused said: What function do you use to get the value of one cell to be 50 for every 1000 value of another cell? Click to expand... =A1/20
B Billy Liddel Feb 15, 2010 #4 If you want for 1000 = 50 and 2000 = 100 then =A1*.05 this will return 37.5 for a value of 750 if you only want it to increase when a value increases by 1000 try =INT(A1/1000)*50 HTH Peter
If you want for 1000 = 50 and 2000 = 100 then =A1*.05 this will return 37.5 for a value of 750 if you only want it to increase when a value increases by 1000 try =INT(A1/1000)*50 HTH Peter
