Calcular Max Con Dos Condiciones_io

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Calcular Max Con Dos Condiciones_io as PDF for free.

More details

  • Words: 62
  • Pages: 1
Sexo V F V V F V

Edad 9 10 69 45 31 32

V V F

21 19 16

F V V V V F F V F F V F

32 78 56 34 12 32 67 45 23 90 95 96

Mayor fémina Mayor hombre

Todas matriciales 96 =MAX(SI(A2:A24="F";B2:B24;"")) 95 =MAX(SI(A2:A24="V";B2:B24;""))

Menor fémina Menor hombre

10 =MIN(SI(A2:A24="F";B2:B24;"")) 9 =MIN(SI(A2:A24="V";B2:B24;""))

Related Documents