Related:
- Sheetformula
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- How to open excel sheet in notepad++ - Guide
- How to screenshot excel sheet - Guide
1 response
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Apr 3, 2010 at 06:02 AM
Apr 3, 2010 at 06:02 AM
some more clarification.
is the iT, sV and T always 1000?
if so, you can do the following as all we need to do is concentrate on the Letters and not the 1000.
try the following
For this example.
=IF(A8="iT",56.02,IF(A8="sV",56,IF(A8="T",54.96)))
A8 will be the cell where you put the Letters (iT,sV or T)
The second cell ie B8 is irrelevant as this number stays the same ( from what i understand)
the formula should be placed in C8., Now what ever you put in A8 (iT,sV,T) the correct figure will appear in C8.
You can have a nest of up to 8 items.
Then copy the formula to all the cells below in the C column.
Hope that helps, Please get back if it does not do what it says on the tin and I will endeavor to help.
is the iT, sV and T always 1000?
if so, you can do the following as all we need to do is concentrate on the Letters and not the 1000.
try the following
For this example.
=IF(A8="iT",56.02,IF(A8="sV",56,IF(A8="T",54.96)))
A8 will be the cell where you put the Letters (iT,sV or T)
The second cell ie B8 is irrelevant as this number stays the same ( from what i understand)
the formula should be placed in C8., Now what ever you put in A8 (iT,sV,T) the correct figure will appear in C8.
You can have a nest of up to 8 items.
Then copy the formula to all the cells below in the C column.
Hope that helps, Please get back if it does not do what it says on the tin and I will endeavor to help.
Apr 3, 2010 at 08:51 AM
Thanks a million for the help so far. My apology for sending ample info. Below a bit more detail
I have a table in spread sheet 1 (a reference sheet providing all the answers).
A B C
1 I T 1200 68.65
2 I T 1450 85.88
3 T 1000 54.96
4 T 1160 65.12
5 I T 1600 94.38
6 V 1600 98.01
7 N T 1160 65.13
8 T 2000 120.13
9 S V 1800 109.32
10 C 2000 117.32
Then I have a second spread sheet see below, where I have to insert the correct answer into column three alongside the appropriate cell.
A B C
1 T 1000 ?
2 I T 1600 ?
3 I T 1200
4 I T 1000
5 T 1160
6 I T 1450
7 IT 1000
8 T 1000
9 S V 1800
10 T 1160
11 I T 1450
12 V 1600
13 C 2000
14 C 2000
15 T 1160
16 T 1000
17 S V 1800
18 I T 1450
19 V 1600
20 T 1160
21 C 2000
22 N T 1160
I need a formula that can transfer the answer from worksheet one to the appropriate cell in worksheet 2.
Alternatively I can copy the table onto worksheet 2 then I don't have to have hyperlinks, if it would simplify the formula?
Lastly please excuse my ignorance I have only a very understanding of excel.
Thanx
Apr 3, 2010 at 09:01 AM
My apology for not providing adequate info first the time.
I have a table in spread sheet 1 (a reference sheet providing all the answers).
A B C
1 I T 1200 68.65
2 I T 1450 85.88
3 T 1000 54.96
4 T 1160 65.12
5 I T 1600 94.38
6 V 1600 98.01
7 N T 1160 65.13
8 T 2000 120.13
9 S V 1800 109.32
10 C 2000 117.32
Then I have a second spread sheet see below, where I have to insert the correct answer into the appropriate cell under column 3
A B C
1 T 1000
2 I T 1600
3 I T 1200
4 I T 1000
5 T 1160
6 I T 1450
7 IT 1000
8 T 1000
9 S V 1800
10 T 1160
11 I T 1450
12 V 1600
13 C 2000
14 C 2000
15 T 1160
16 T 1000
17 S V 1800
18 I T 1450
19 V 1600
20 T 1160
I need a formula that can transfer the answer from worksheet one to the appropriate cell in worksheet 2. Alternatively I can copy the table from spread sheet 1 onto a vacant section on spread sheet 2 to eliminate the hyperlink of the formula ?
Thanx in advance.