IF Statements

ashleykay31

New Member
Joined
Nov 9, 2005
Messages
3
Okay I have a excel document that has 8 sheets in it. On the First page I want to put an IF statement in. For the IF statement it needs to say IF you enter "1" into a certain cell that it would change the sales tax in another cell. Does that make sense?

And then in one sheet when you enter a something into a certain cell i want to be able to have it automaticall copy over to another sheet in a certain cell. Any help at all would be effective im sure. I've been working on this project for a week and I can't figure it out.

Thanks So much!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Welcome to MrExcel - worksheet formulas cannot directly alter any cell but the one they are in.

You can, however do this:

1] Enter your 1/etc in a cell - assume A1

2] in your sales tax cell, enter: =IF(A1=1,.085,.075)

What are the entire range of sales tax figures you'd be dealing with?
 

ashleykay31

New Member
Joined
Nov 9, 2005
Messages
3
Well right now its just two different sales tax..it would be .005 and .006...So We were thinking that if you entered 1 into A1 and then O into A2 then we could get the right sales tax, but then we want the same for the opposite. if we enter 1 into A2 and 0 into A1 then we would get the other sales tax to pop up? Does that make any sense? I've been working on this..and its driving me insane not to figure it out!
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
For multiple choices you'd be better off with a lookup table. See the below.
Book2
ABCD
26$ 125.00$ 10.63
3
Sheet2
Book2
ABCD
116.75%
227.00%
337.25%
447.50%
558.00%
668.50%
778.75%
885.00%
9910.00%
1000.00%
Sheet3
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,994
Messages
5,834,775
Members
430,321
Latest member
yemisimi11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top