make formula max at 100%

[nparsons75]

Hi,

I am using the following formula, would it be possible to ensure the result never exceeds 100%?

=INT(R15-R13)/(R14-R13)

Thanks

 

[JackDanIce]

Try:

=MAX(1,INT(R15-R13)/(R14-R13))

 

[Aladin Akyurek]

Try:

=MAX(1,INT(R15-R13)/(R14-R13))

You meant MIN... I guess.

 

[JackDanIce]

@Aladin Akyurek you guessed corrected, thank you for spotting! I was thinking floors and ceilings and mixed myself up!

Corrected:

=MIN(1,INT(R15-R13)/(R14-R13))

 

[nparsons75]

Hi,

No MAX. The formula is currently returning 120%, I need it to show 100% at maximum. The value relates to the progress of a project, its not possible to complete it 120% so once the value reached 100%, I want the value to max at that.

Hope that makes sense, difficult to explain clearly.

Thanks,

 

[nparsons75]

Having said all that....the one that worked is MIN....

My misunderstanding how this works, thank you very much.

 

[JackDanIce]

You're welcome