need help with multiple formulas in one cell

[stearnslending]

Theres a couple things i want to do in one cell.

I have three cells.

The first two cells B6 and B7 have two values

In the third cell B9 I have an existing formula =ROUNDDOWN(MIN(B6,B7),0)

It works great, it inputs the lower value of the two. Now, heres my problem.

In the same cell B9 I would like to also add another layer. If the lower of the two is greater than 5000 input $5000

I cannot figure it out. PLEASE HELLP!!

 

[ChrisR]

=If(ROUNDDOWN(MIN(B6,B7),0) <5000,5000,ROUNDDOWN(MIN(B6,B7),0)

 

[stearnslending]

wow, that was fast, it didnt work though

 

[ChrisR]

Apologies, I misread the original question.......Just change the '<' for a '>'

So

=If(ROUNDDOWN(MIN(B6,B7),0) >5000,5000,ROUNDDOWN(MIN(B6,B7),0)

 

[stearnslending]

no worries, that didnt work though either. It says I have too many arguments for this function

 

[ChrisR]

Not sure why?

Try this..........Only difference is a bracket, but excel should add that automatically anyway........This works fine on mine?

=IF(ROUNDDOWN(MIN(B6,B7),0)>5000,5000,ROUNDDOWN(MIN(B6,B7),0))

If you have issues, can you copy and paste your exact formula you are having the issue with onto this post?

 

[stearnslending]

that worked!! thank you so much!

 

[ChrisR]

Thanks for letting me know!