Forum Discussion

wenhua's avatar
wenhua
Copper Contributor
Apr 27, 2020

Auto show blank if specific text is shown

Fruits : Apple 1 box $19.80  $  19.80 Fruits : orange 1 pcs $2.30  $    2.30 Others  : Minimum Charges 1 nos $800.00  $800.00                             ...
excel
wenhua's avatar
wenhua
Copper Contributor
Apr 27, 2020
i had figured out ,
=IF(F30="Minimum Charges",O30*L30,IF(COUNTIF($F$21:$K$59,"Minimum Charges"),"",IF(L30="","",O30*L30)))

Resources