SOLVED

Trying to get IF formula

New Contributor

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

2A

B

3$183.58$185.00
4$188.34$189.00

Thanks for your help

3 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@KorbiDall 

 

Please try this...

 

In B3

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

and then copy it down.

Thank you! Worked great!@Subodh_Tiwari_sktneer 

You're welcome @KorbiDall!