View Single Post
  #3   Report Post  
 
Posts: n/a
Default 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.