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
Column A Column B
I don’t know how to write the fomula to do this.