Auto show blank if specific text is shown

Copper 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
i had figured out ,
=IF(F30="Minimum Charges",O30*L30,IF(COUNTIF($F$21:$K$59,"Minimum Charges"),"",IF(L30="","",O30*L30)))