Formula question

[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

 

[Fran]

The answer will be in another cell C10

 

[schoujar]

OK assuming that you meant 6% of A1 and you are not storing the value i
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 th
formula) are formatted to display data as currency

Cheers

Sahi

 

[schoujar]

the just paste

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

in C10

and format C10 as currency

hope it helps

Sahil

 

[Ardus Petus]

=MAX(A1*.06,5)

HTH

 

[Dana DeLouis]

Maybe this idea?

=MIN(A1*6%, 5)