Prev: IF formula help
Next: SAMPLE EXCEL DATA
From: Steve Dunn on 30 Apr 2010 08:47
Another possibility:

=(AE9=35)*((J9=1)+(J9="M")+(J9="C"))*((B9="Z")*1000+(B9="A+")*750)


"Woodi2" <Woodi2(a)discussions.microsoft.com> wrote in message
news:2880A23A-DA26-40D5-8AAC-0B7CB5D54E4A(a)microsoft.com...
> Is it possible to make this function work?
>
> =IF(AND(AND($B9="Z",AE9=35),OR(J9=1,J9="M",J9="C")),1000,IF(AND(AND($B9="A+",AE9=35),OR(J9=1,J9="M",J9="C")),750))
>
> I need to find out if Cell B9 = Z and if Cell AE9 = 35, if this true then
> check cell J9 and check if it equals 1, M or C then return the value as
> 1000.
> (that bit works OK)
> I also want it to check if an alternative statement is true if the first
> is
> false whereby it checks the the same set of cells but this time, check if
> B9
> =A+, if Cell AE9 = 35, if this true then check cell J9 and check if it
> equals
> 1, M or C then return the value as 750. I can get each function to work
> individually but dont know how to combine it into one function.

First  |  Prev  | 
Pages: 1 2
Prev: IF formula help
Next: SAMPLE EXCEL DATA