Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =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))))))
- POR SI LA ANTERIOR FALLARA:
- =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))))))
- ESTA DEBERÍA FUNCIONAR:
- =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