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: 61
Default Multiple AND OR functions

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.
 
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
Multiple IF functions Jafferi[_2_] Excel Worksheet Functions 6 April 8th 09 07:13 AM
Multiple functions, conditional functions HeatherBelle Excel Worksheet Functions 7 October 17th 08 03:57 PM
Index & Match functions - multiple criteria and multiple results [email protected] Excel Worksheet Functions 4 May 2nd 07 03:13 AM
Multiple IF functions questionsforms Excel Worksheet Functions 2 October 30th 05 03:12 AM
Multiple IF functions sonicj Excel Worksheet Functions 3 February 2nd 05 03:31 AM


All times are GMT +1. The time now is 12:02 PM.

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

About Us

"It's about Microsoft Excel"