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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
How to enter formula to give warnings 2
If statement for a range of cells 3
if then this statements 1
Formula? 14
Help needed for inexperienced MS Excel 2003 user 2
IF Statement 5
sum if 3

Top