Argument problem
caroj59 wrote:
I need help with this formula.
Cell A1=$1001.00
Cell B1=$1002.00
I need C1 to =( B1*1% ) only if B1 is equal to
or greater then A1
You also have to decide what C1 should be if the
condition is not met (i.e, B1 is less than A1).
Here is the basic paradigm for C1:
=IF(B1 = A1, B1*1%, ...)
You need to fill in "..." with the formula that
you want.
|