Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3079159%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3079159%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I%20work%20as%20a%20sales%20representative%20and%20use%20excel%20as%20a%20tool%20to%20calculate%20e.g.%20order%20value%2C%20etc.%20I%20have%20made%20formulas%20for%20the%20spinner%20where%20you%20have%20to%20fill%20in%204%20different%20values.%20b2%20C2%20D2%20and%20G2%20make%20to%20get%20H2.%20The%20problem%20is%20that%20each%20line%20needs%20to%20be%20able%20to%20fill%20this%20out%20for%20a%20new%20company.%20How%20can%20I%20solve%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3079159%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello! I work as a sales representative and use excel as a tool to calculate e.g. order value, etc. I have made formulas for the spinner where you have to fill in 4 different values. b2 C2 D2 and G2 make to get H2. The problem is that each line needs to be able to fill this out for a new company. How can I solve this?

1 Reply

@Emil_Sarnehed 

With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5
 

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

 

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)