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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago