Help with simple IF statement
Why is the formula =IF(B17>10,"B17*.5",IF(B17<=10,"5*1"))
producing "B17*.5" and not calculating what the product of cell B17 and .5 is?
I need to create a formula that says "If Cell A's number is 10 or less, Cell B is '5' and if Cell A's number is greater than 10, Cell B is half of Cell A"
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago