Jun 25 2022 06:03 PM
I would like to know how to write a formula for the following
If A3 is less than B1, I want B1 value to appear in B3
If A3 is more than B1, I want the A3 value to appear in B3 rounded to the nearest dollar
1 | $185.00 | |
2 | A | B |
3 | $183.58 | $185.00 |
4 | $188.34 | $189.00 |
Thanks for your help
Jun 25 2022 06:51 PM
SolutionJun 25 2022 06:51 PM
Solution
Please try this...
In B3
=IF(A3<$B$1,$B$1,ROUNDUP(A3,0))
and then copy it down.