General discussion
December 24, 2005 at 10:11 AM
blginger

Excel nexted functions

by blginger . Updated 20 years, 9 months ago

I’m trying to count student attendance if they are Special Education students, ie =if(f15=”P”+ae15=”1″),1,0 (if one cell is “P” AND another cell is “1” then return “1”)
This returns “invalid” or “value” and function doesn’t work. When I get the function to work, it returns an incorrect value. How can I get this to work?

This discussion is locked

All Comments