S sdmccabe Mar 3, 2008 #1 Please help define an if statement that puts the value $100 in a cell when another calls value is greater than or equal to 20%.
Please help define an if statement that puts the value $100 in a cell when another calls value is greater than or equal to 20%.
T T. Valko Mar 3, 2008 #2 Suppose you want cell A1 to return 100 when cell B1>=20%. Enter this formula in cell A1: =IF(AND(COUNT(B1),B1>=20%),100,0)
Suppose you want cell A1 to return 100 when cell B1>=20%. Enter this formula in cell A1: =IF(AND(COUNT(B1),B1>=20%),100,0)
