CaReCoiN

Excel Thiago

Apr 10th, 2014
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. =SI(G6="Frutas";SI(H6>=300;M6*0,05;SI(H6>=600;M6*0,1;SI(H6>=1000;M6*0,15;SI(H6>=1500;M6*0,2))));SI(G6="Verduras";SI(H6>=300;M6*0,03;SI(H6>=600;M6*0,07;SI(H6>=1000;M6*0,09;SI(H6>=1500;M6*0,12))))))
  2.  
  3. POR SI LA ANTERIOR FALLARA:
  4.  
  5. =SI(G6="Frutas";SI(H6>=1500;M6*0,2;SI(H6>=1000;M6*0,15;SI(H6>=600;M6*0,1;SI(H6>=300;M6*0,05))));SI(G6="Verduras";SI(H6>=1500;M6*0,12;SI(H6>=1000;M6*0,09;SI(H6>=600;M6*0,07;SI(H6>=300;M6*0,03))))))
  6.  
  7. ESTA DEBERÍA FUNCIONAR:
  8.  
  9. =SI(G6="Frutas";SI(H6>=1500;J6*0,2;SI(H6>=1000;J6*0,15;SI(H6>=600;J6*0,1;SI(H6>=300;J6*0,05))));SI(G6="Verduras";SI(H6>=1500;J6*0,12;SI(H6>=1000;J6*0,09;SI(H6>=600;J6*0,07;SI(H6>=300;J6*0,03))))))
Advertisement
Add Comment
Please, Sign In to add comment