Forum Discussion
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 |
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)))
