if statement
 

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%.

if statement
 

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)


--
Biff
Microsoft Excel MVP


"sdmccabe" wrote in message
...
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%.