Auto show blank if specific text is shown

%3CLINGO-SUB%20id%3D%22lingo-sub-1339874%22%20slang%3D%22en-US%22%3EAuto%20show%20blank%20if%20specific%20text%20is%20shown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339874%22%20slang%3D%22en-US%22%3E%3CTABLE%20width%3D%22647px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22253px%22%20height%3D%2257px%22%3EFruits%3C%2FTD%3E%3CTD%20width%3D%2242px%22%20height%3D%2257px%22%3E%3A%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3EApple%3C%2FTD%3E%3CTD%20width%3D%2251px%22%20height%3D%2257px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2257px%22%3Ebox%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%2419.80%3C%2FTD%3E%3CTD%20width%3D%2296px%22%20height%3D%2257px%22%3E%26nbsp%3B%3CFONT%20color%3D%22%23FF6600%22%3E%24%26nbsp%3B%2019.80%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22253px%22%20height%3D%2257px%22%3EFruits%3C%2FTD%3E%3CTD%20width%3D%2242px%22%20height%3D%2257px%22%3E%3A%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3Eorange%3C%2FTD%3E%3CTD%20width%3D%2251px%22%20height%3D%2257px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2257px%22%3Epcs%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%242.30%3C%2FTD%3E%3CTD%20width%3D%2296px%22%20height%3D%2257px%22%3E%26nbsp%3B%3CFONT%20color%3D%22%23FF6600%22%3E%24%26nbsp%3B%20%26nbsp%3B%202.30%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22253px%22%20height%3D%2257px%22%3EOthers%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2242px%22%20height%3D%2257px%22%3E%3A%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3EMinimum%20Charges%3C%2FTD%3E%3CTD%20width%3D%2251px%22%20height%3D%2257px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2257px%22%3Enos%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%24800.00%3C%2FTD%3E%3CTD%20width%3D%2296px%22%20height%3D%2257px%22%3E%26nbsp%3B%24800.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22253px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2242px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2296px%22%20height%3D%2230px%22%3E%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22253px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2242px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2296px%22%20height%3D%2230px%22%3E%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22253px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2242px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2296px%22%20height%3D%2230px%22%3E%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22253px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2242px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2296px%22%20height%3D%2230px%22%3E%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22253px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2242px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2296px%22%20height%3D%2230px%22%3E%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22253px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2242px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2296px%22%20height%3D%2230px%22%3E%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20do%20i%20auto%20show%20blanket(those%20in%20orange)%20if%20i%20select%20minimum%20charges%20(%20at%20any%20row)%3F%26nbsp%3B%3C%2FP%3E%3CP%3EMean%20i%20could%20have%205%20fruit%20but%20if%20the%20fruit%20does%20not%20cost%20more%20than%20%24800%20%2C%20i%20would%20only%20want%20to%20show%20the%20%24800%20the%20rest%20i%20wan%20it%20blanket%20.%20so%20that%20my%20total%20reflect%20only%20%24800%20and%20not%20%24822.10.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1339874%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339933%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20show%20blank%20if%20specific%20text%20is%20shown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339933%22%20slang%3D%22en-US%22%3Ei%20had%20figured%20out%20%2C%3CBR%20%2F%3E%3DIF(F30%3D%22Minimum%20Charges%22%2CO30*L30%2CIF(COUNTIF(%24F%2421%3A%24K%2459%2C%22Minimum%20Charges%22)%2C%22%22%2CIF(L30%3D%22%22%2C%22%22%2CO30*L30)))%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Fruits:Apple1box$19.80 $  19.80
Fruits:orange1pcs$2.30 $    2.30
Others :Minimum Charges1nos$800.00 $800.00
        
        
        
        
        
        

 

Hi, 

i do i auto show blanket(those in orange) if i select minimum charges ( at any row)? 

Mean i could have 5 fruit but if the fruit does not cost more than $800 , i would only want to show the $800 the rest i wan it blanket . so that my total reflect only $800 and not $822.10.

1 Reply
Highlighted
i had figured out ,
=IF(F30="Minimum Charges",O30*L30,IF(COUNTIF($F$21:$K$59,"Minimum Charges"),"",IF(L30="","",O30*L30)))