a1=

Hi all, I have a sheet that has columns of numbers (lets say like below) A1= 1500 A2= _ A3= _ Or A1= _ A2= 1500 A3= _ They are all filled using formulas (lets say using a vlookup on another sheet). They may sometimes be blank as shown in the examples above. Only one will ever be populated...

Hi Guys, I am trying to write an if statement based on the results in cell A1 and i cant seem to get this correct the rules i want to apply in the statement are If A1 > 0.49 then A1=100 If A1 > 0.39 and less then 0.50 then A1=75 If A1 >0.29 and less then 0.40 then A1= 50 how can i write this...

How can I convert 19 years 6 months into 19.5 years in excel? A1= 19 years 6 months, B1=19.5 years

Hello all, Can someone please help me with the following: I need to look at 3 cells then colour one of them depending all values. I.E. cell A1=10000, B1= 5.7 and C1=a symbol like >>. So i need B1 to change to green if A1= between 5000 and 15000 and B1 is less than 6 and C1=>> Thanks -...

I feel like the answer is NO but I thought I should ask: If A1= list of currencies (USD, AUD, CAD, EUR, GBP) Can A2= a number with the correct currency symbol from A1 Example: A1= USD A2= $300 A1= AUD A2= AUD 600 A1=CAD A2= CAD 100 A1= EUR A2= €500 A1= GBP A2= £240

Hi, is it possible to create a formula which creates a sum of a range(A1:E1) but values > 8 are cutoff? Example: A1= 8,5 B1 = 10 C1 = 8 D1 = 7 E1 = 0 SUM should be 8+8+8+7+0 Cheers Max

I want to create two cell, 1st cell value will be between score 0-100, 2nd cell will be shown in % based on the value in the 1st cell Example: 1st cell is A1 and 2nd is A2 When A1= 98-100, A2=100% When A1= 97-91, A2=90% When A1= 90-86, A2=80% When A1= 85-81, A2=70% When A1= 80-76, A2=60%...