Problem with an IF argument

  • Thread starter Thread starter kje.1953
  • Start date Start date
K

kje.1953

How do I show this formula?

If (Column S85=24) + (Column U85=33.00) then column U85*AE2), OR
If (Column S85=24) + (column U85=34.67) then column U85*AE3), OR
IF(Column S85=24) + (column U85=39.50) then (column U85*AE4), OR
IF(column S85=36) + (column U85=33.00) then (column U85*Ah2), OR
IF(column S85=36) + (column U85=34.67) then (column U85*Ah3), OR
IF(column S85=36) + (column U85=39.50) then (column U85*Ah4)

Excel 2003
 
kje.1953 said:
How do I show this formula?

If (Column S85=24) + (Column U85=33.00) then column U85*AE2), OR
If (Column S85=24) + (column U85=34.67) then column U85*AE3), OR
IF(Column S85=24) + (column U85=39.50) then (column U85*AE4), OR
IF(column S85=36) + (column U85=33.00) then (column U85*Ah2), OR
IF(column S85=36) + (column U85=34.67) then (column U85*Ah3), OR
IF(column S85=36) + (column U85=39.50) then (column U85*Ah4)

Excel 2003
Click to expand...

Please ask your Excel question in a discussion group for Excel. This group
is for .NET programming discussions, and you're unlikely to get useful
answers here.

To find the discussion group you need, try this:

As you appear to be using a web interface, try this:

http://www.microsoft.com/communities/newsgroups/en-us/

In the tree on the left, open English, then open Office and Desktop
Applications. In the Office and Desktop Applications
subcategory, find and open the subcategory for Excel, and find a group
there for your post.
 
KJE is correct. However, there are a couple ways to solve your problem.

The first is with a nested if like you are attempting here. I caution you
because I believe there is a limit of 16 nests. The syntax is
if(condition1, <true statement>, <else statement>); you would just keep
putting your if statements in the <else statements> until your chain is
complete.

if(S85+U85 = 57, U85 *AE2, <else condition>)

The second and more scalable would be to use a vlookup to complete your
logic.

On a seperate sheet:

A
Search 1
Search 2
Search 3

Search values would be the possible sums of S85 and U85

B
Value 1
Value 2
Value 3

Value values would be 0 and the values you have in AE2-AE4 and AH2-AH3

Select both columns and define a lable for the table (i.e. Multiplier)

Then in your targe cell create a formula =if(iserror(Vlookup(S85 + U85,
Multiplier, true)),0,Vlookup(S85 + U85, Multiplier, true) * U85)


If you need to test the values of S85 and U85 seperately, you would be best
to use a DLookup. I caution you here, because domain searches are very
slow.
 
Back
Top