Results 1 to 4 of 4
Thread: Excel

20090803, 16:50 #1
 Join Date
 Aug 2009
 Posts
 3
 Thanks
 0
 Thanked 0 Times in 0 Posts
I'm a newbie with Excel and am not familiar with the jargon or syntax!
Can do the simple +  * etc. But I'm having trouble understanding the 'help' info.
This is an example of what I'm trying to do.............
Cell under A contains .... 2 Cell under B .... 10 Cell under C .... 0.25 Cell under D... 0.2
Cell under E .... Will be left blank, and into which at a later time, will have a text entry, being
either W or L or P4 or P5 or W/P4 or W/P5
Cell F will be the result of one of five equations, depending on the entery under E
Cell G will be the result of an equation only if L was entered under E
Examples : F1 will equal (providing E1 has the text W/P4 entered) the sum of (2*10) and
(2*10*0.25)
G1 will contain the result of 2*10 only if an L was entered in E1
All my attempts are greeted with 'not valid'!!! Help, please.

20090803, 17:17 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 Posts
Welcome to the Lounge!
The formula in G1 could look like this:
=IF(E1="L",A1*B1,"")
If E1 equals "L", the formula returns the value of A1*B1, otherwise it returns an empty string.
The formula in F1 will be much more complicated. It'd be something like
=IF(E1="W",11,IF(E1="L",22,IF(E1="P4",33,IF(E1="P5 ",44,IF(E1="W/P4",A1*B1+A1*B1*C1,IF(E1="W/P5",66,""))))))
where 11, 22, 33, 44 and 66 will have to be replaced with the expressions you want there.
I have attached a sample workbook with these formulas.

20090804, 04:27 #3
 Join Date
 Aug 2009
 Posts
 3
 Thanks
 0
 Thanked 0 Times in 0 Posts
[quote name='HansV' post='787409' date='03Aug2009 17:17']Welcome to the Lounge!
The formula in G1 could look like this:
=IF(E1="L",A1*B1,"")
If E1 equals "L", the formula returns the value of A1*B1, otherwise it returns an empty string.
The formula in F1 will be much more complicated. It'd be something like
=IF(E1="W",11,IF(E1="L",22,IF(E1="P4",33,IF(E1="P5 ",44,IF(E1="W/P4",A1*B1+A1*B1*C1,IF(E1="W/P5",66,""))))))
where 11, 22, 33, 44 and 66 will have to be replaced with the expressions you want there.
I have attached a sample workbook with these formulas.[/quote]

20090804, 04:35 #4
 Join Date
 Aug 2009
 Posts
 3
 Thanks
 0
 Thanked 0 Times in 0 Posts
Many thanks Hans. I'll try it out when I have some time......maybe tomorrow.
Regards
Don