Correct value not showing

[Turbonetics282]

Hello,

I'm trying to get the correct value to show in my spreadsheet. It can't go over a maximum value and it can't go below a minimum value. If the calculation is between those two values, I want it to show. Here is the formula that I've come up with so far:

=IF(B25>B26,B26)+IF(B25<B27,B27)+IF(AND(B25<B26,B25),B25>B27,B25)

The formula works up until the IF(AND portion. The value it is giving is a 1. The number that it should be showing is a number between the min and max. I'm not sure if using the "IF" function is the right approach but I figured I'd ask you guys.

Any help is appreciated, thanks.

 

[Turbonetics282]

I just noticed that the formula didn't paste correctly. It is:

=IF(B25>B26,B26)+IF(B25<B27,B27)+IF(AND(B25<B26,B25),B25>B27,B25)

 

[Turbonetics282]

Not sure why it's cutting off. Let's try again.

=IF(B25>B26,B26)+IF(B25<<b27,b27) IF(AND(B25<B26,B25),B25="" +="">B27,B27)+IF(AND(B25<<b26,b25),b25>B26,B25),B25>B27,B25)</b26,b25),b25></b27,b27)>