LinkBack URL
About LinkBacks
Can anyone explain in a simple way what I have missed in this formula.
I don’t get the expected result (please see attachment).
=IF(OR(COUNTIF(A6:$A$11;$D$1);IF(AND($C$11>SUM(B5:$B$11);(B5/2)>(SUM(B5:$B$11)-$C$11));"";$D$1));"";$D$1)
Tommy
Can anyone explain in a simple way what I have missed in this formula.
I don’t get the expected result (please see attachment).
=IF(OR(COUNTIF(A6:$A$11;$D$1);IF(AND($C$11>SUM(B5:$B$11);(B5/2)>(SUM(B5:$B$11)-$C$11));"";$D$1));"";$D$1)
Tommy
Last edited by tomjoe; 01-08-2011 at 06:29 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks