Formula question-I am trying to work out?

[Fran]

I am trying to work out a formula and need a little help.

I need something like this

IF A1 * 6% EQUALS < $5.00
IF TRUE-IT WOULD EQUAL A1 * 6%
IF NOT TRUE-IT WOULD EQUAL $5.00

[schoujar]

by "A1 * 6%"

do u mean 6% of A1?
and do u want to store the result back in A1? or some other cell?

Cheers

Sahil

[schoujar]

OK assuming that you meant 6% of A1 and you are not storing the value in A1 the following can be used:

=IF((0.06*A1)<5,(0.06*A1),5)

You can use this function in, for example, cell B1.

Make sure that both A1 and B1 (or the cell in which you use the formula) are formatted to display data as currency

Cheers

Sahil

[Fran]

The answer will be in another cell C10


"schoujar" <schoujar.28pk3m_1149139500.411@excelforum-nospam.com> wrote in
message news:schoujar.28pk3m_1149139500.411@excelforum-nospam.com...
>
> by "A1 * 6%"
>
> do u mean 6% of A1?
> and do u want to store the result back in A1? or some other cell?
>
> Cheers
>
> Sahil
>
>
> --
> schoujar
> ------------------------------------------------------------------------
> schoujar's Profile:
> http://www.excelforum.com/member.php...o&userid=26574
> View this thread: http://www.excelforum.com/showthread...hreadid=547322
>

[schoujar]

then just paste

=IF((0.06*A1)<5,(0.06*A1),5)

in C10

and format C10 as currency

hope it helps

Sahil

[Dana DeLouis]

Maybe this idea?

=MIN(A1*6%, 5)
--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003


"Fran" <fpeale@comcast.net> wrote in message
news:uRNvHmThGHA.3924@TK2MSFTNGP03.phx.gbl...
>I am trying to work out a formula and need a little help.
>
> I need something like this
>
> IF A1 * 6% EQUALS < $5.00
> IF TRUE-IT WOULD EQUAL A1 * 6%
> IF NOT TRUE-IT WOULD EQUAL $5.00
>

[Ardus Petus]

=MAX(A1*.06,5)

HTH
--
AP

"Fran" <fpeale@comcast.net> a écrit dans le message de news:
uRNvHmThGHA.3924@TK2MSFTNGP03.phx.gbl...
>I am trying to work out a formula and need a little help.
>
> I need something like this
>
> IF A1 * 6% EQUALS < $5.00
> IF TRUE-IT WOULD EQUAL A1 * 6%
> IF NOT TRUE-IT WOULD EQUAL $5.00
>