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!
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,084
Messages
5,570,131
Members
412,305
Latest member
Mozz
Top