If less than

[RodneyW]

I want to modify this formula

=(BF70/1000)*$BG$4

So that if the result is equal to or greater than the value I have in BG2, enter that value. If the result is less than value I have in BG2, use the value I have cell BG3.

Thank you in advance

 

[mumps]

Try: =IF((BF70/1000)*$BG$4>=BG2,BG2,BG3)

 

[RodneyW]

YAHTZEE! This helped tremendously. Thank you

 

[mumps]

My pleasure.