Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rounding
Hello!
I use this formula to retrive prices from different pricelists. For the first two pricelists i want to round of the price to zero decimals and for the last one leave the price as it is from the pricelist. I use Windows XP and Excel XP, Swedish version. =OM(W10="Förnöd";INDEX(Prislista!$A$5:$AF$173;PASS A(X10&T10;Prislista!$A$5:$A$173&Prislista!$B$5:$B$ 173;0);PASSA(V10;Prislista!$A$4:$AP$4;1));OM(W10=" Lös";INDEX(Prislista!$A$183:$K$285;PASSA(X10&T10;P rislista!$A$183:$A$285&Prislista!$B$183:$B$285;0); PASSA(V10;Prislista!$A$182:AP$182;1));OM(W10="Kli" ;INDEX(Kli!$A$3:$J24;PASSA(J10&N10;Kli!$A$3:$A$24& Kli!$B$3:$B$24;0);PASSA("Pris";Kli!$A$2:$G$2;1));0 ))) PASSA=MATCH OM=IF Hope you understands what I mean Tia Ola Sigurdh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unwanted rounding of large number | Excel Worksheet Functions | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |