if statement

S

sdmccabe

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

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)
 
Top