Argument problem

C

caroj59

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


I keep getting "#NAME" in the cell using my formula,,, obviously does
not work.

I discovered that sleeping during high school algelbra is now catching
up to me.

thank you for any help.

Jim
 
J

joeu2004

caroj59 said:
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
Click to expand...

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.
 
R

Ron Rosenfeld

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


I keep getting "#NAME" in the cell using my formula,,, obviously does
not work.

I discovered that sleeping during high school algelbra is now catching
up to me.

thank you for any help.

Jim
Click to expand...

I do not see your formula in this post. Could you repeat it?


--ron
 
Top