SOLVED

Auto calculate to find number needed for a percent

%3CLINGO-SUB%20id%3D%22lingo-sub-2455043%22%20slang%3D%22en-US%22%3EAuto%20calculate%20to%20find%20number%20needed%20for%20a%20percent%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2455043%22%20slang%3D%22en-US%22%3EHello!%20I%20need%20some%20help%20please!%3CBR%20%2F%3ETrying%20to%20find%20a%20way%20to%20auto%20calculate%20what%20is%20needed%20to%20get%20a%20certain%20percentage.%3CBR%20%2F%3EFor%20example%3A%3CBR%20%2F%3EIf%20I%20have%2050%20of%20100%20(50%25)%20how%20do%20I%20auto%20calculate%20what%20is%20needed%20to%20reach%2080%25%3CBR%20%2F%3EI%20feel%20like%20this%20is%20easy%20and%20I%20am%20over%20thinking%20this.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2455043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2455212%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20calculate%20to%20find%20number%20needed%20for%20a%20percent%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2455212%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1080658%22%20target%3D%22_blank%22%3E%40Alindamood%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20100%20is%20in%20A2%2C%20the%20current%20value%2050%20is%20in%20B2%2C%20and%20the%20desired%20percentage%2080%25%20is%20in%20C2.%3C%2FP%3E%0A%3CP%3EThe%20formula%20you%20want%20is%20%3DC2*A2-B2%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0513.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F289310i2C6B1DFD125B5830%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0513.png%22%20alt%3D%22S0513.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2500986%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20calculate%20to%20find%20number%20needed%20for%20a%20percent%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2500986%22%20slang%3D%22en-US%22%3EThis%20worked%20for%20what%20I%20essentially%20needed%20it%20to%20do.%20Thank%20you%20very%20much!%20But%20one%20more%20question.%20I%20am%20using%20this%20formula%20to%20solve%20what%20is%20needed%20to%20get%20to%20that%20certain%20percentage%20for%20two%20percentages%20(let's%20just%20say%2080%20and%2090%25).%20I%20am%20finding%20a%20few%20instances%20where%20the%20answer%20from%20the%20formula%20is%20a%20negative%20number.%20Is%20there%20a%20formula%20I%20can%20use%20to%20show%20%22N%2FA%22%20if%20there%20is%20a%20negative%20number%3F%20Thinking%20this%20would%20be%20an%20If%20Then%20formula%3F%20Thanks!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2501091%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20calculate%20to%20find%20number%20needed%20for%20a%20percent%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2501091%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1080658%22%20target%3D%22_blank%22%3E%40Alindamood%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20would%20be%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(C2*A2-B2%26lt%3B0%2C%22N%2FA%22%2CC2*A2-B2)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hello! I need some help please!
Trying to find a way to auto calculate what is needed to get a certain percentage.
For example:
If I have 50 of 100 (50%) how do I auto calculate what is needed to reach 80%
I feel like this is easy and I am over thinking this.
4 Replies

@Alindamood 

Let's say 100 is in A2, the current value 50 is in B2, and the desired percentage 80% is in C2.

The formula you want is =C2*A2-B2

 

S0513.png

This worked for what I essentially needed it to do. Thank you very much! But one more question. I am using this formula to solve what is needed to get to that certain percentage for two percentages (let's just say 80 and 90%). I am finding a few instances where the answer from the formula is a negative number. Is there a formula I can use to show "N/A" if there is a negative number? Thinking this would be an If Then formula? Thanks!
best response confirmed by allyreckerman (Microsoft)
Solution

@Alindamood 

That would be

 

=IF(C2*A2-B2<0,"N/A",C2*A2-B2)

That worked! Thank you!!