Related:
- If condition in excel
- Number to words in excel - Guide
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
2 responses
write formula:
=IF(A2="a",100000-(100000*16%),B2)
where A2=cell name representing A or B
100000 is total sales value
=IF(A2="a",100000-(100000*16%),B2)
where A2=cell name representing A or B
100000 is total sales value