SOLVED

using decimal percentage values in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2010175%22%20slang%3D%22en-US%22%3Eusing%20decimal%20percentage%20values%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010175%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20formula%20would%20I%20need%20to%20use%20in%20excel%20for%20this%20as%20excel%20doesn't%20calculate%200.35%25%20using%20this%20formula%26nbsp%3B%20%3Da1*b1%2Bc1%26nbsp%3B%3C%2FP%3E%3CP%3EIe%2015%2C332.92%20*%200.19497503%20%2B%200.35%25%20%3D%202%2C999.99%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2010175%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-2010195%22%20slang%3D%22en-US%22%3ERe%3A%20using%20decimal%20percentage%20values%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010195%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909168%22%20target%3D%22_blank%22%3E%40userm2300%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20add%20two%200%20after%20the%20point.%3C%2FP%3E%3CP%3E%3CSPAN%3E15%2C332.92%20*%200.19497503%20%2B%200.0035%20%3D%202989.54%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2010237%22%20slang%3D%22en-US%22%3ERe%3A%20using%20decimal%20percentage%20values%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010237%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F87534%22%20target%3D%22_blank%22%3E%40Jihad%20Al-Jarady%3C%2FA%3E%26nbsp%3BHi%20Jihad%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20the%20reply%2C%20i%20just%20tested%20it%20and%20it%20gives%20me%26nbsp%3B2%2C989.54%20instead%20of%26nbsp%3B2%2C999.99%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2010245%22%20slang%3D%22en-US%22%3ERe%3A%20using%20decimal%20percentage%20values%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010245%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909168%22%20target%3D%22_blank%22%3E%40userm2300%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20shall%20work%20if%20you%20enter%20it%20correctly%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F242262i4BA9E5FDFA55C3B9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2010256%22%20slang%3D%22en-US%22%3ERe%3A%20using%20decimal%20percentage%20values%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010256%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909168%22%20target%3D%22_blank%22%3E%40userm2300%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20so%20you%20mean%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20215px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F242270i99AA00B99A4FF46B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2010407%22%20slang%3D%22en-US%22%3ERe%3A%20using%20decimal%20percentage%20values%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010407%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bhow%20should%20the%20formula%20look%20with%20the%20values%20in%20the%20cells%20like%20this%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22276%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2282%22%3E%C2%A315%2C332.92%3C%2FTD%3E%3CTD%20width%3D%2282%22%3E0.35%25%3C%2FTD%3E%3CTD%20width%3D%22112%22%3E0.19497503%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

What formula would I need to use in excel for this as excel doesn't calculate 0.35% using this formula  =a1*b1+c1 

Ie 15,332.92 * 0.19497503 + 0.35% = 2,999.99

9 Replies

Hi @userm2300 

 

Just add two 0 after the point.

15,332.92 * 0.19497503 + 0.0035 = 2989.54

 

 

 

* If my post helped you, please click on like.

@Jihad Al-Jarady Hi Jihad,

 

thanks for the reply, i just tested it and it gives me 2,989.54 instead of 2,999.99

@userm2300 

It shall work if you enter it correctly

image.png

@userm2300 

If so you mean

image.png

@Sergei Baklan how should the formula look with the values in the cells like this 

 

£15,332.920.35%0.19497503

Hi @userm2300 

 

Applying the number format, from the drop down list.

format.png

best response confirmed by userm2300 (Occasional Contributor)
Solution

@userm2300 

Exactly the same way. If you have value 10 in the cell, Excel could show it to you as 10, as 10.00, as $10.0, as £10.00, whatever, depends on which format do you use. But it still will be 10.

image.png

Even better to use references on other cells, not numbers directly, like

image.png

If you apply to the result currency format, number will be shown in rounded form, but actual value still will be 2999.9999... You shall take that into account, and if in other calculations you'd like to use exactly three thousand pound, use ROUND() function or like.

@Sergei Baklan Absolute champion, that is exactly what I needed work’s like a charm, thank you sir

@userm2300 

Glad to help. Happy Holidays!