Need help to expand IF formula please

[leopardhawk]

The formula below works as intended but I need some help please, to expand the formula so that if F31 is greater than 0 but less than 1195, it would return F31 and if F31 is greater than 1195, it would return 1195.

=IF(F31>0,E27, 0)

Thanks!

 

[jtakw]

Hi,

Based on your description, and assuming E27 is No longer involved:

Book1
	A	F
1	1195
31		1196
Sheet662

Cell Formulas
Range	Formula
A1	=IF(F31>0,MIN(F31,1195),0)

 

[leopardhawk]

Thanks for your reply but E27 is definitely involved, it is where the 1195 amount resides. I make the mistake sometimes of my explanation lacking enough or the correct information.

Let's assume that the formula is in cell F50.

1. E27 contains the 1195 amount
2. F31 can be any amount from 0 - infinity
3. If F31 is 0, then the formula should return 0
4. If F31 is greater than 0, then the formula should return E27
5. If F31 is greater than 0 but less than E27, the formula should return F31

Sorry about the confusion (my end) but am still hoping someone can help.

Thanks!

 

[Fluff]

Maybe
=MIN(F31,E27)

 

[jtakw]

Then just swap out 1195 with E27:

Book1
	E	F
27	1195
28
29
30
31		999
50		999
Sheet662

Cell Formulas
Range	Formula
F50	=IF(F31>0,MIN(F31,E27),0)

 

[leopardhawk]

Works perfectly! Thanks for everyone's help!

 

[Fluff]

You're welcome & thanks for the feedback

 

[jtakw]

You're welcome, thanks for the feedback.