SOLVED

Formulas and Functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2584580%22%20slang%3D%22en-US%22%3EFormulas%20and%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2584580%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon%2C%3C%2FP%3E%3CP%3EI%20need%20a%20calculation%20and%20I%20can't%20quite%20figure%20it%20out%20on%20my%20own.%3C%2FP%3E%3CP%3EWe%20have%20for%20weighed%20products%20which%20belong%20to%20a%20certain%20entered%20width.%20Suppose%20I%20have%20a%20number%20between%201%20and%20100%20then%20I%20need%201%20product.%3C%2FP%3E%3CP%3EBut%20if%20I%20have%20a%20width%20between%20101%20and%20200%20then%20I%20need%202%20of%20those%20products%20and%20if%20between%20201%20and%20300%20I%20need%203%20and%20so%20on.%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20with%20how%20to%20calculate%20this%20in%20excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2584580%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2584616%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20and%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2584616%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1112064%22%20target%3D%22_blank%22%3E%40DUVELISO%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20you%20enter%20a%20number%20in%20A2.%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%20in%20B2%3A%20%3DROUNDUP(A2%2F100%2C0)%3C%2FP%3E%0A%3CP%3EThis%20can%20be%20filled%20down%20if%20you%20have%20more%20numbers%20in%20A3%2C%20A4%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2584619%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20and%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2584619%22%20slang%3D%22en-US%22%3EBedankt%20Hans%20maar%20dat%20lijkt%20niet%20te%20werken%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2584641%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20and%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2584641%22%20slang%3D%22en-US%22%3EDat%20werkt%20wel%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20Ik%20had%20je%20formule%20gekopieerd%20%3DAFRONDEN.NAAR.BOVEN(A2%2F100%2C0)%20met%20een%20komma%20tussen%20de%20%2F100%2C0%20maar%20dat%20moest%20een%20%3B%20zijn.%3CBR%20%2F%3E%3CBR%20%2F%3EHet%20werk%20nu!%20Heel%20erg%20bedankt.%3C%2FLINGO-BODY%3E
New Contributor

Good afternoon,

I need a calculation and I can't quite figure it out on my own.

We have for weighed products which belong to a certain entered width. Suppose I have a number between 1 and 100 then I need 1 product.

But if I have a width between 101 and 200 then I need 2 of those products and if between 201 and 300 I need 3 and so on.

Can someone help me with how to calculate this in excel?

 

Thanks.

4 Replies

@DUVELISO 

Let's say you enter a number in A2.

Enter the following formula in B2: =ROUNDUP(A2/100,0)

This can be filled down if you have more numbers in A3, A4 etc.

Bedankt Hans maar dat lijkt niet te werken
best response confirmed by DUVELISO (New Contributor)
Solution

@DUVELISO 

Wat is het probleem?

Als je komma als decimaalscheider gebruikt, moet je puntkomma in de formule gebruiken:

 

=ROUNDUP(A2/100;0)

 

of in het Nederlands

 

=AFRONDEN.NAAR.BOVEN(A2/100;0)

Dat werkt wel Ik had je formule gekopieerd =AFRONDEN.NAAR.BOVEN(A2/100,0) met een komma tussen de /100,0 maar dat moest een ; zijn.

Het werk nu! Heel erg bedankt.