| 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? |
| 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 | |||
Threaded Mode
