Clarifications on Excel

Hello Gurus ,
I have a scenario in excel , where I have three cells
Cell 1 is the Qty
Cell 2 is the unit price
Cell 3 is the total price

there is formula added Cell 3 = Cell 2 * Cell 1
Now I don't want to show the value of Cell 1 and needs to mention as " LS" .

Question is : how can I change the particar cell ( in this case , Cell 1) to "LS" , without affecting the formulae of calculation

Regards,

Sid
infiniti7181Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
What is LS?
0
infiniti7181Author Commented:
Sorry I meant lumpsum as "LS" , so that I don't want to reveal the quantities
0
Roy CoxGroup Finance ManagerCommented:
So is LS a always the same value?
0
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

can you step back and explain the bigger picture? As in "why" do you need to hide the quantity? If the total is the product of quantity and unit price, it can be calculated from the total price.  

What do you want to achieve? Maybe there are different approaches.

cheers, teylyn
0
infiniti7181Author Commented:
hi , all
just to rephrase my requirement

the sheet is a Bill of Material , so when I prepare a particular cell lets say example shown below.

Description           Qty      Unit Price    Total Price
Services Prices        1            20                    20

consider the example , total price is formulated to be Unit times Qty

Now , I want to change the Qty 1 to be renamed as LS' Lumpsum' . inorder not to affect the formula . So that whoever reads the excel will not see the quantities mentioned .
What I know , if I format that particular cell , it can be renamed to whatever words you need to type on it .

BR
0
Roy CoxGroup Finance ManagerCommented:
It's still not clear. Will only one cell be used for QTY. Will quantities vary?

 If you want to hide the contents of the formula then use Sheet protection
1. First select all the cells on the sheet by pressing the icon next to A and above 1.
2.Right click on the sheet and choose Format cells
3.In the Protection Tab clear the selections
4.Next select the cell(s) with Formulas
5.Format cells -> Protection and tick both boxes.

Protect the sheet and the formulas will not be visible.
0
Saqib Husain, SyedEngineerCommented:
You can try a formula like

=IF(B5="LS",C5,C5*B5)

as shown in the attached file.
LSformula.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Roy CoxGroup Finance ManagerCommented:
Possibly you can create a Named Range on a hidden sheet called LS then enter quantirties in that cell. The formula in the Bill would be

=LS*G2
LS.xlsx
0
Saqib Husain, SyedEngineerCommented:
Some of the accepted comments are not solutions. The two solutions are miles apart. They both cannot be correct. Please explain the distribution of points. Also please tell us what was deficient in the solutions which deserved a B grade.
0
Roy CoxGroup Finance ManagerCommented:
We now have a request for clarification marked as accepted solution!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.