Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to do a calculation based on the values in two cells
Hi
I need help with Excel 2007 This is the sample data: A1 B1 C1 D1 100 0 1 400 1 1 500 1 0 200 0 0 Scenario 1: If B1=0 And C1=1 then calculate D1 as a percentage of A1 Scenario 2: If B1=1 and C1=1 then D1=0 Scenario 3: If B1=1 And C1=0 then D1=0 Scenario 3: If both B1 and C1=0 then D1=0 NB: B AND C ARE ALWAYS EITHER 1 OR 0 How do i build the function to perform these calculations in column D dependant on the values in B and C? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to do a calculation based on the values in two cells
calculate D1 as a percentage of A1
Not sure I understand. Do you mean express the value of A1 as a percentage? =IF(AND(B1=0,C1=1),A1/100,0) Format as Percentage -- Biff Microsoft Excel MVP "NakesGP" wrote in message ... Hi I need help with Excel 2007 This is the sample data: A1 B1 C1 D1 100 0 1 400 1 1 500 1 0 200 0 0 Scenario 1: If B1=0 And C1=1 then calculate D1 as a percentage of A1 Scenario 2: If B1=1 and C1=1 then D1=0 Scenario 3: If B1=1 And C1=0 then D1=0 Scenario 3: If both B1 and C1=0 then D1=0 NB: B AND C ARE ALWAYS EITHER 1 OR 0 How do i build the function to perform these calculations in column D dependant on the values in B and C? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to do a calculation based on the values in two cells
Something like:
=IF(AND(B1=0,C1=1),0.4*A1,0) where the .4 is actually your value. -- Gary''s Student - gsnu200901 "NakesGP" wrote: Hi I need help with Excel 2007 This is the sample data: A1 B1 C1 D1 100 0 1 400 1 1 500 1 0 200 0 0 Scenario 1: If B1=0 And C1=1 then calculate D1 as a percentage of A1 Scenario 2: If B1=1 and C1=1 then D1=0 Scenario 3: If B1=1 And C1=0 then D1=0 Scenario 3: If both B1 and C1=0 then D1=0 NB: B AND C ARE ALWAYS EITHER 1 OR 0 How do i build the function to perform these calculations in column D dependant on the values in B and C? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum the values of cells based on fontcolor | Excel Worksheet Functions | |||
Calculation based on Y or N Values | Excel Discussion (Misc queries) | |||
Sumif based on different values in different cells | Excel Discussion (Misc queries) | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
Populating cells based on calculation | Excel Worksheet Functions |