If you need urgent support, call 999 or go to your nearest A&E. To contact our Crisis Messenger (open 24/7) text THEMIX to 85258.
Options
Excel 2003 help - Tax
Former Member
Posts: 1,876,323 The Mix Honorary Guru
in General Chat
I have a question for my IDA class to do with tax calculations and I don't know what to do for one of them.
SALES TAX IS CHARGED ON THE INCOME FROM ALL PRODUCTS AT THE RATE CONTAINED IN THE C10 CELL IF INCOME EXCEEDS £1000 BUT AT THE RATE CONTAINED IN THE C11 CELL IF INCOME IS LESS THAN OR EQUAL TO £1000.
6A WRITE A FORMULA IN E13 TO CALCULATE THE TAX DUE ON SALES OF BEANS. THEN COPY THIS FORMULA INTO THE REST OF COLUMN E TO GIVE THE TAX DUE ON EACH OF THE OTHER PRODUCTS.
I thought I would do an IF Statement to determine the tax rate and in the same IF statement make one of the answers a calculation but it just turns out like:
=IF(D13>1000,"=(D13*$C$10)/100","=(D13*$C$11)/100")
and doesn't return an actual calculation.
Help!
SALES TAX IS CHARGED ON THE INCOME FROM ALL PRODUCTS AT THE RATE CONTAINED IN THE C10 CELL IF INCOME EXCEEDS £1000 BUT AT THE RATE CONTAINED IN THE C11 CELL IF INCOME IS LESS THAN OR EQUAL TO £1000.
6A WRITE A FORMULA IN E13 TO CALCULATE THE TAX DUE ON SALES OF BEANS. THEN COPY THIS FORMULA INTO THE REST OF COLUMN E TO GIVE THE TAX DUE ON EACH OF THE OTHER PRODUCTS.
I thought I would do an IF Statement to determine the tax rate and in the same IF statement make one of the answers a calculation but it just turns out like:
=IF(D13>1000,"=(D13*$C$10)/100","=(D13*$C$11)/100")
and doesn't return an actual calculation.
Help!
0
Comments
=IF(D13>1000,(D13*$C$10)/100,(D13*$C$11)/100)
think you were right except it doesnt need the extra " or =
:thumb:
good luck!