View Single Post
 
Old 03-08-2018, 02:07 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Code:
=if(k2="","",if(o2>0,"complete",(today()-k2+1)*h2))
or
Code:
=if(SUM(k2)=0,0,if(o2>0,"complete",(today()-k2+1)*h2))
Reply With Quote