Published on Planning Planet (http://www.planningplanet.com)

Home > Discussion Forum > IF OR Fuction

IF OR Fuction

By Jithin Kambhikanam
Created 24 May 2022 - 10:03
Submitted by Jithin Kambhikanam on Tue, 2022-05-24 10:03

Hello All,

 

Need a help.

A formula to calulate the % duration complete based on IF OR function in excel

 

   Today = (D)28-May-22
ItemABDuration% Complete
Item 123-May-2228-May-226B=D,100%, A<D,B>A,(D-A+1)/(B-A+1)
Item 225-May-221-Jun-228 


Thanks

Jithin

By logging in, inputting data or deciding to view any further of our pages you agree to be bound by our Forum Rules, our T&C's and also our Privacy Policy
© Planning Planet 2000-2024. Run by Project Controllers for Project Controllers.
Source URL: http://www.planningplanet.com/forums/planning-scheduling-programming-discussion/915637/if-or-fuction

Links:
[1] http://www.planningplanet.com/forums/planning-scheduling-programming-discussion