excel prb 1

[ptweb]

Hi

I have this prob, I need to the "AND format for excel on the first IF statement, not sure what it is..

if not NO AND another cell not yes... ..I hope my formula helps
=IF(F201<>"no",


SUM((I201)*7/47),IF(J201>0,IF(LEN(J201)>0,IF(G201="yes",SUM((I201)*7/47),SUM((J201)*7/47)),""),""))

 

[Lilliabeth]

ya got a lot of summing going on - not sure what you're after, but this should help...

=IF(AND(G201<>"yes",J201<>"no"),"apples","peaches")

 

[ptweb]

In english (for me) does this say, if the cell is not equal to no and the other cell is not equal to yes then... blah blah

 

[firefytr]

In plain english ...

If G201 is not equal to "yes" AND J201 is not equal to "no" then put "apples", or else put "peaches". That what you're looking for?

-----------
Regards,
Zack Barresse

 

[ptweb]

Yes thats great thxs