Aug 20 2021 05:26 AM
Using Microsoft Windows 10 and Office 365 for business
I currently have a formula currently in the cell and can use the =Max function to have a "At least" number but also need it to say 0 if there is no data in the previous formula.
So =K18*C18*(1+$G$2+$P$6) and if the returns >.5 then I want it to be .5 But if there is no data in K18 or C18 I want it to read 0
I tried =Max(K18*C18*(1+$G$2+$P$6),.05) but it defaults to .05 when there is no data in K18 or C18
Please I would welcome any input.
Aug 20 2021 05:29 AM
SolutionAug 20 2021 05:38 AM
Aug 20 2021 05:44 AM
=MEDIAN(K18*C18*(1+$G$2+$P$6),0.5,0)
Aug 20 2021 05:29 AM
SolutionUse
=IF(OR(K18="",C18=""),0,MAX(K18*C18*(1+$G$2+$P$6),.05))