IF Statements

[ashleykay31]

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!

 

[just_jon]

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]

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]

For multiple choices you'd be better off with a lookup table. See the below.

Book2
	A	B	C	D
2	6	$ 125.00	$ 10.63
3
Sheet2

Book2
	A	B	C	D
1	1	6.75%
2	2	7.00%
3	3	7.25%
4	4	7.50%
5	5	8.00%
6	6	8.50%
7	7	8.75%
8	8	5.00%
9	9	10.00%
10	0	0.00%
Sheet3