If D3="E" or "E/P" show I15+M15+Q15, else show 0, else if D3="P" or "S" show I20+m20+q20, else show 0
If D3="E" or "E/P" show I15+M15+Q15, else show 0, else if D3="P" or "S" show I20+m20+q20, else show 0
Try
=IF(OR(D3="E", D3="E/P"), I15+M15+Q15, IF(OR(D3="P", D3="S"), I20+M20+Q20, 0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks