excel problem

[ricker]

I am trying to do something in excell.
In one worksheet I have a cell in which you can enter one or the othe
of these text.
Lower or
ts or
upper.
on this same worksheet i have a value of a number, say like 12.
Then on another worksheet I am trying to make a formula whereas, if th
cell on the other page is filled with lower it will the cell on the 1s
sheet as 12. The same would be for if I entered ts. But it would nee
to automaticly subtract .5 from the cell with 12 if I the othe
worksheet had entered upper in it.

something like this senerio
if lower is entered in cell c2 cell f2 = 12
if upper is entered in cell c2 cell f2 = 11.5
if ts is entered in cell c2 cell f2 = 12

Help Ric

 

[mudraker]

Paste this formula into f2

=IF(OR(Sheet1!C2="lower",Sheet1!C1="ts"),12,IF(Sheet1!C1="lower",11.5,""))

change sheet1 with your sheet nam

 

[DDM]

ricker, mudraker's formula can be simplified as follows:

=IF(OR(Sheet1!C2="lower",Sheet1!C1="ts"),12,11.5)

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com

 

[ricker]

Worked great Mudraker. You solved a poblem that I have spent all weeken
trying to do. That is why I got on this forum. I knew it should beabl
to be done, but not being proficiant in excel, could not figure ou
where the OR went.
It did not work exactly until I changed the last from lower to upper.

(OR(Sheet1!C2="lower",Sheet1!C1="ts"),12,IF(Sheet1!C1="upper",11.5,""))

Thank a heap!!!

Rick Royer
Spokane, Wa

 

[JE McGimpsey]

No, it can't.

But from the OP's post it appears a better formula is

=IF(OR(Sheet1!C2="lower",Sheet1!C2="ts"),12,
IF(Sheet1!C2="upper",11.5,""))

since the OP doesn't say what should happen if there's no value entered
in Sheet1!C2 (I assume the cell should be blank).

If, on the other hand, Sheet1!C2 will always be filled with one of the
three options, a modification of your formula would be most efficient:

=IF(Sheet1!C2="upper",11.5,12)

 

[ricker]

Hello Mudraker, I forgot to mention that the cell that has the 12 is
variable cell that I change so where I have the 12 it needs to ente
what ever is in the cell

F2

Here is what I have.
Work order sheet
C D E F column letter
1 Type L R W
2 upper ce ce 24
3 lower 12
4 ts 12

My other page called back

A B C D E F
1 Back width
2 11.5
3 12
4 12
So if I enter 24 in F2 of the work order sheet. cell F2 of the bac
page would need to say 23.

 

[JE McGimpsey]

One way:

=Sheet1!F2 - 0.5*(Sheet1!C2="upper")

 

[mudraker]

=IF(OR(Sheet1!C2="lower",Sheet1!C1="ts"),Sheet1!F2,IF(Sheet1!C1="lower",Sheet1!F2-0.5,"")