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
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