Argument problem

[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

[duane]

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

assuming you want zero if b1<a1

[joeu2004@hotmail.com]

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.

[Ron Rosenfeld]

On Sun, 30 Oct 2005 19:01:22 -0600, caroj59
<caroj59.1xqs2b_1130720703.9737@excelforum-nospam.com> 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