IF Function

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

2 thoughts on “IF Function

  1. andrew walker Post author

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *