Trying to get IF formula

[KorbiDall]

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

[#2 · Accepted solution]

@KorbiDall 

Please try this...

In B3

=IF(A3<$B$1,$B$1,ROUNDUP(A3,0))

and then copy it down.

[#3]

Thank you! Worked great!@Subodh_Tiwari_sktneer 

[#4]

You're welcome @KorbiDall!