Pull data from a cell relative to a function

[cooder187]

I have searched this forum for something similar but haven't found what I was looking.
Yes I'm looking for help and yes I'm a novice.

I am looking to Have a cell value that would be a max limit in relation to a function.

So A1=4
B1=9 B2=2
I want to try and make This =IF(B1-B2>0,ROUND(((B1-B2)),0),0)
and incorporate this into it =IF(result of last function>=A1,A1,result of function)

I want to be able to change the value of A1 and have it be reflected into the formula.

Does this make sense? Im not sure how to put it all together.

[FDibbins]

Hi and welcome ot the forum

Maybe this?

=IF(IF(B1-B2>0,ROUND(((B1-B2)),0),0)>=A1,A1,IF(B1-B2>0,ROUND(((B1-B2)),0),0))

[cooder187]

Yes, I knew there had to be a way to nest that in there, Thank you!

[FDibbins]

Happy to help and thanks for the feedback