View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gemsera Gemsera is offline
external usenet poster
 
Posts: 3
Default Multiple IF Statements with Three Variables

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