# Excel formula problem

Solved/Closed
Related:

- Excel formula problem
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel free download - Download - Spreadsheets

## 2 responses

RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120

Apr 4, 2011 at 04:19 AM

Apr 4, 2011 at 04:19 AM

please provide a sample of how your sheets look like or upload a sample of your workbook using a site like www.speedyshare.com. Also re-explain what you would like to see happen in more detail for better understanding.

Apr 4, 2011 at 04:42 AM

Sale 50% 30% 20% Status

R 10,000.00 R 5,000.00 R 3,000.00 R 2,000.00 1

I have a sales value of 10 000, if my status is 1 then 50 30 and 20% must show and calculate, but if status is 2 the 50% shows false or 0 and 30 and 20 counts/ show, same with status 3, 50 and 30 dont count / false, only 20% show.

Thanks