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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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?
 
Upvote 0
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!
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,211,963
Messages
6,105,107
Members
447,947
Latest member
OX_2005

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
Back
Top