SOLVED

Usinf Max Value in a cell with formula

Copper 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 (Copper 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)
1 best response

Accepted Solutions
best response confirmed by Kevin1969 (Copper Contributor)
Solution

@Kevin1969 

Use

 

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

View solution in original post