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

Page numbering with Merged Document and IF statements 1
Greater Less or Equal 3
VBA Coding Help for Beginner 0
Weigh tasks 0
Word 2013 field code Nested IF statement 1
How to enter formula to give warnings 2
If statement for a range of cells 3
Use TODAY() function as the criteria in a SUMIF formula 1

Top