Let me give a detailed explanation.
I have three columns K14,L14 AND M14 which can be populated with either 0 or 1 or 2.
Lets pretend C75 is always YES.
If any one of the columns > 0 then 60
If any two of the columns > 0 then 120
If all 3 columns > 0 the 150
or
=IF(C75="yes",IF(COUNT(K14:M14)=1,60,IF(COUNT(K14:M14)=2,120,IF(COUNT(K14:M14)=3,150,0))),0)
The original I posted should have been
=IF(AND(C75="yes",K14>0,L14>0,M14>0),150,IF(AND(C75="yes",K14>0,L14>0),120,IF(AND(C75="yes",K14>0),60,0)))
Basic error on order of criteria (by me!)
See Beamernsw for neat solution.
Last edited by JohnTopley; 01-04-2016 at 10:41 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks