Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi All,
After a thorough search I couldnt see anything related or similar, so unfortunately I have to ask the question. I have three variables I need to calculate: Software Build Hardware Type Project Phase The spreadsheet is a list of faults reported on the software. The goal is to list in the table which phase each fault is for, so we can do a total. I have done the preliminary list which is similar to this (for each hardware, software and phase): IF I1 = Hardware-EMS AND J1 = V07.01.00S00 OR J1 = V07.01.00S101 THEN print Phase 1 thats the basics of what I require, but I require it for 14 different combinations. I really do hope someone can help, as this would make such a difference to our reporting. Thank you in advance for any help at all. x |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If,Then for multiple variables. | Excel Discussion (Misc queries) | |||
Multiple variables-SOS | Excel Worksheet Functions | |||
look for a value with multiple variables | Excel Discussion (Misc queries) | |||
Sumif with multiple variables | Excel Discussion (Misc queries) | |||
IF statements with more than 7 variables | Excel Worksheet Functions |