tylerschreck
New Member
- Joined
- Jun 13, 2008
- Messages
- 2
I have a vlookup formula that divides...what I need to have is one that will multiply. I can't figure it out...
This is the one that divided the numbers...how would I make one that multiplies them?
=C41/VLOOKUP(E41,{0.6,720;0.7,570;0.8,450;0.9,360;1,300;1.1,240;
1.2,210;1.3,180;1.4,150;1.5,120;1.6,45;1.7,1;1.8,1;1.9,1;2,1;2.1,1;
2.2,1;2.3,1;2.4,1;2.5,1;2.6,1;2.7,1;2.8,1;2.9,1;3,1},2,FALSE)
This is the one that divided the numbers...how would I make one that multiplies them?
=C41/VLOOKUP(E41,{0.6,720;0.7,570;0.8,450;0.9,360;1,300;1.1,240;
1.2,210;1.3,180;1.4,150;1.5,120;1.6,45;1.7,1;1.8,1;1.9,1;2,1;2.1,1;
2.2,1;2.3,1;2.4,1;2.5,1;2.6,1;2.7,1;2.8,1;2.9,1;3,1},2,FALSE)