For the life of me I cannot get this to work. I get to many arguments
=IF(AND(B151=0,B196=0),(B106+B151+B196),IF(AND(B151>0,B196=0),(B106+B151+B196)/2)IF(AND(B151>0,B196>0),(B106+B151+B196)/3))
It only works with these 2
=IF(AND(B151>0,B196=0),(B106+B151+B196)/2
Any help would be appreciated.
Thanks,
Bob
Bookmarks