#### johnandbeth

##### Board Regular

- Joined
- Apr 8, 2002

- Messages
- 168

1) I have applied ROUND to a cell. I then want to multiply the rounded value by another cell. Currently, it multiplies by the actual number, not the rounded value. How do I multiply the rounded value?

2) I want a formula for if the number in this cell is greater than x, multiply by a, if the cell is less than x, multiply by b.

Thanks for the help,

~Beth