SOLVED

Usinf Max Value in a cell with formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2668905%22%20slang%3D%22en-US%22%3EUsinf%20Max%20Value%20in%20a%20cell%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2668905%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20Microsoft%20Windows%2010%20and%20Office%20365%20for%20business%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20currently%20have%20a%20formula%20currently%20in%20the%20cell%20and%20can%20use%20the%20%3DMax%20function%20to%20have%20a%20%22At%20least%22%20number%20but%20also%20need%20it%20to%20say%200%20if%20there%20is%20no%20data%20in%20the%20previous%20formula.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%26nbsp%3B%3DK18*C18*(1%2B%24G%242%2B%24P%246)%20and%20if%20the%20returns%20%26gt%3B.5%20then%20I%20want%20it%20to%20be%20.5%26nbsp%3B%20%26nbsp%3BBut%20if%20there%20is%20no%20data%20in%20K18%20or%20C18%20I%20want%20it%20to%20read%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20%3DMax(K18*C18*(1%2B%24G%242%2B%24P%246)%2C.05)%20but%20it%20defaults%20to%20.05%20when%20there%20is%20no%20data%20in%20K18%20or%20C18%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20I%20would%20welcome%20any%20input.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2668905%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2668936%22%20slang%3D%22en-US%22%3ERe%3A%20Usinf%20Max%20Value%20in%20a%20cell%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2668936%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1132719%22%20target%3D%22_blank%22%3E%40Kevin1969%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(OR(K18%3D%22%22%2CC18%3D%22%22)%2C0%2CMAX(K18*C18*(1%2B%24G%242%2B%24P%246)%2C.05))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2668959%22%20slang%3D%22en-US%22%3ERe%3A%20Usinf%20Max%20Value%20in%20a%20cell%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2668959%22%20slang%3D%22en-US%22%3EThank%20you%2C%20I%20tried%20that%20earlier%20but%20had%20it%20in%20the%20wrong%20order.%20Much%20obliged%20of%20your%20help!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2668964%22%20slang%3D%22en-US%22%3ERe%3A%20Usinf%20Max%20Value%20in%20a%20cell%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2668964%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1132719%22%20target%3D%22_blank%22%3E%40Kevin1969%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DMEDIAN(K18*C18*(1%2B%24G%242%2B%24P%246)%2C0.5%2C0)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

 

 

 

3 Replies
best response confirmed by Kevin1969 (New Contributor)
Solution

@Kevin1969 

Use

 

=IF(OR(K18="",C18=""),0,MAX(K18*C18*(1+$G$2+$P$6),.05))

Thank you, I tried that earlier but had it in the wrong order. Much obliged of your help!

@Kevin1969 

=MEDIAN(K18*C18*(1+$G$2+$P$6),0.5,0)