Murugesh Siva
New Member
Hi,
I am Murugesh, I am a test administrator in Corporate house. I have been trying to pull a pivot and have been get poor results
In a day I run close to a 100 tests with 2 vendors for which I have to compartmentalize the scores in groups of 50's. I used the If(OR(AND formula like
=IF(OR(AND(B:B>=400,B:B<450)),1,"")
while the result is right, it does provide a '1', my pivot says otherwise, I get extras. I am wondering if my formula is right. I also need to post the results in Excel 2003, 2007 and 2013 cause a lot of people are still using 2003.
Thank you
I am Murugesh, I am a test administrator in Corporate house. I have been trying to pull a pivot and have been get poor results
In a day I run close to a 100 tests with 2 vendors for which I have to compartmentalize the scores in groups of 50's. I used the If(OR(AND formula like
=IF(OR(AND(B:B>=400,B:B<450)),1,"")
while the result is right, it does provide a '1', my pivot says otherwise, I get extras. I am wondering if my formula is right. I also need to post the results in Excel 2003, 2007 and 2013 cause a lot of people are still using 2003.
Thank you