Hi guys,
I need to calculate the median EV/EBITDA for e.g. year 2009 when sales in the US are > 50%.
=MEDIAN(IF(A1:A21=2009,IF(B1:B21>50%,G1:G21,0)))
This formula works.
But now want to built a new function with a nested IF function, but I can't get it right. For example: return the median EV/EBITDA for 2009 with North America >50%, EU>10% and EM>10%.
I used MEDIAN(IF(A1:A21=2009,IF(AND(B1:B21>50%, C1:C21>10%, D1:D22>50%), G1:G21,0))) but it keeps returning #NUM.
Anyone that has a solution or can you tell what I'm doing wrong?
I need to calculate the median EV/EBITDA for e.g. year 2009 when sales in the US are > 50%.
=MEDIAN(IF(A1:A21=2009,IF(B1:B21>50%,G1:G21,0)))
This formula works.
But now want to built a new function with a nested IF function, but I can't get it right. For example: return the median EV/EBITDA for 2009 with North America >50%, EU>10% and EM>10%.
I used MEDIAN(IF(A1:A21=2009,IF(AND(B1:B21>50%, C1:C21>10%, D1:D22>50%), G1:G21,0))) but it keeps returning #NUM.
Anyone that has a solution or can you tell what I'm doing wrong?