1. 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.

2. 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.

3. [quote name='HansV' post='787409' date='03-Aug-2009 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]

4. Many thanks Hans. I'll try it out when I have some time......maybe tomorrow.
Regards
Don

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•