Help with this formula

[Aimee S.]

Hi again folks!

=IF(AND(C4<>"ISP & OSP - PRC",'2-FactoryRefinedDataPull'!M3:N3<>""),MAX('2-FactoryRefinedDataPull'!N4,'2-FactoryRefinedDataPull'!M4),"")

I tried this on my own and it isn't quite working right.

Look at C4 and if value there does not equal "ISP & OSP - PRC" *and* there is no value in either of cells '2-FactoryRefinedDataPull'!N4 or '2-FactoryRefinedDataPull'!M4, make C4 blank.

If C4 has value that does not equal "ISP & OSP - PRC" and there *is* a value in range '2-FactoryRefinedDataPull'!N4:'2-FactoryRefinedDataPull'!M4
have C4 show the MAX of any available values in range
'2-FactoryRefinedDataPull'!N4:'2-FactoryRefinedDataPull'!M4


Aimee in Madtown

 

[texasalynn]

does this help?

=IF(AND("ISP & OSP - PRC"<>C4,COUNTA('2-FactoryRefinedDataPull'!M3:N3)<>0),
     MAX('2-FactoryRefinedDataPull'!N4,'2-FactoryRefinedDataPull'!M4),"")

 

[Aimee S.]

Whoo hoo! Thank you!!!!!!!