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


--
caroj59
------------------------------------------------------------------------
caroj59's Profile: http://www.excelforum.com/member.php...o&userid=28447
View this thread: http://www.excelforum.com/showthread...hreadid=480480

=if(b1<a1,0,b1*1.01)

assuming you want zero if b1<a1


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=480480

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.

On Sun, 30 Oct 2005 19:01:22 -0600, 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


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

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


--ron