I have column a which has dollar figures in it.

I have column b which I want to have a formula to fill in. That would be

If amount in column a is less than $147.00 than column b whould show that total, but if column a is greater than $147.00 column be should be $147.00

Example

Column A Column B

$331.37 $147.00

$25.66 $25.66

I don’t know how to write the fomula to do this.

By: Donna

## You might also find helpful in Excel...

Hi there… try this formula…

`=IF(A1<147,A1,147)`

This says if A1 less than (<) 147 then display the value in A1, otherwise display 147.

Try it…

Formula type in cell B1 (Cell must be in dollar format)

=if(A1>147,147,A1)