LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If,Then for multiple variables. Eden397 Excel Discussion (Misc queries) 1 June 10th 08 09:46 PM
Multiple variables-SOS Ang Excel Worksheet Functions 3 April 27th 07 08:24 PM
look for a value with multiple variables Andrea Excel Discussion (Misc queries) 2 January 18th 07 12:24 PM
Sumif with multiple variables les8 Excel Discussion (Misc queries) 5 April 8th 06 02:16 AM
IF statements with more than 7 variables Liv4fun Excel Worksheet Functions 8 November 18th 05 03:26 PM


All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"