Old Feb 25, 2009 | 04:02 PM
  #8  
Neil S's Avatar
Neil S
PassionFord Post Troll
20 Year Member
iTrader: (1)
 
Joined: May 2003
Posts: 2,815
Likes: 0
From: Cleveland
Default

In the cell you want the 9.5hrs to appear, I would use a function something like:

=if(or(A1="H",A1="S",A1="X"),9.5,"")

Where A1 is the cell you are testing.

The IF statement says if the following statement is true (the or statement in this case), then set the value of this cell to 9.5, otherwise set it blank.

Another way of explaining it is: If any one of the conditions in the or statement is true then the value will be 9.5, otherwise blank.

PS you need the equals at the beginning of the function so Excel will recognise it as a function.

HTH

Neil.

Last edited by Neil S; Feb 25, 2009 at 08:14 PM.
Reply