Need help conditioning if statement formula

[smgomez]

I have a formula that says: =IF(K17119<>"",0,ROUND(DAYS360(F17119,H17119)/30,0))/100
I need to take that formula and revise so that if the result is greater than 30%, return 30%, else return the result.
where K17119 is blank and F17119 is 1/30/17 and H17119 is 10/7/25
That would result in 59%, but because it is over 30, I want it to return 30
Need help making that happen
Thanks

 

[Alex Blakenburg]

Try:

=IF(K17119<>"",0,MIN(ROUND(DAYS360(F17119,H17119)/30,0)/100,30%))

 

[SanjayGMusafir]

I have a formula that says: =IF(K17119<>"",0,ROUND(DAYS360(F17119,H17119)/30,0))/100
I need to take that formula and revise so that if the result is greater than 30%, return 30%, else return the result.
where K17119 is blank and F17119 is 1/30/17 and H17119 is 10/7/25
That would result in 59%, but because it is over 30, I want it to return 30
Need help making that happen
Thanks

Check this -

=IF(K17119<>"",0,IF(ROUND(DAYS360(F17119,H17119)/30,0)>30,30,ROUND(DAYS360(F17119,H17119)/30,0))/100

Please update your Excel version and Platform your are using in your profile. at times solution depends on the version you are using. Just like in this case.