Formula question

F

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
 
S

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
 
S

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
 
S

schoujar

the just paste

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

in C10

and format C10 as currency

hope it helps

Sahil
 
Top