# I wanted to order another set of the sheets, but not until I find the right price. they were listed for & 10-99 and cost me 24:49 What went wrong ?

Posted by on

### JonSnell Electronic

• Level 3:

An expert who has achieved level 3 by getting 1000 points

Top Expert:

An expert who has finished #1 on the weekly Top 10 Fixya Experts Leaderboard.

Superstar:

An expert that gotÂ 20 achievements.

All-Star:

An expert that gotÂ 10 achievements.

• Televison & ... Master

Only you will know that.

Posted on Dec 02, 2020

### Anonymous

This achieved like this.
In sheet one there is cell where you input discount percentage say for exaple it cell B5. Now this cell needsto formatted to percentage(click location B5 and then right click and select format cell .On number tag select percentage). Also in cell C5 put 75 and it will write 75% as it formated to show percentage.
Let us look at one product and then you can apply the same principle to all products.
Go to sheet2. This will contain full price in one cell and discount price.Let us say full price is in location B10 and you want the discounted price in C10.
Now if the discount is 30 % then obiously you are paying 75% of full price.
To display discount price in sheet2 at C10, you need to enter this formula in C10
C10*sheet2!\$B\$5
Now as soon as your the discount changes C10 will change to reflect the discount rate.

Posted on Oct 13, 2008

×

my-video-file.mp4

×

## Related Questions:

### S it possible to obtain a list of my last 3 items and the price cost of each that I have order

You are on the wrong website for this type of inquiry. This is a self help website for the repair and use of consumer manufactured products..

Jun 22, 2017 | The Computers & Internet

Tip

### Excel- Unhide All Sheets

When we hide worksheets using, still user can right click on tabs and un-hide the worksheets. For example, following example will hide the worksheet and user can un hide the sheets on right click on sheet tabs:
Sub sbHideSheet() Sheets("SheetName").Visible = False 'OR Sheets("SheetName").Visible = xlSheetHidden End Sub What if you do not want to permit users to un-hide worksheet, you can set the Visible property of worksheet to xlSheetVeryHidden and lock the VBA code. so that user can not un-hide the worksheet. The below example will hide the sheet and user can not see it in un hide worksheet dialog list.
```Sub sbVeryHiddenSheet()
Sheets("SheetName").Visible = xlSheetVeryHidden
End Sub
```

on Dec 09, 2016 | Microsoft Excel for PC

Tip

### Missing sheet feeder tray and Dell refused to help + PHD found for \$195

I have had the Dell 2135cn that I got through a trade last year. The entire time, I have not had the sheet feeder tray and was frustrated because Dell said they did not carry that part. I found the part at Impactcomputers.com today for only \$9.95!! While I was there, I ordered the PHD my printer was saying it needed for \$195 instead of the \$250-\$300 I saw at other places. I had to call in to get the special price of \$195, however, because their website has about \$250. I told them I found it elsewhere for \$195 and they gave me the better price. Their shipping cost for both items was only \$10 which seemed within reason, too. Let's hope the parts arrive safely and have the quality I want as well.

on Nov 07, 2011 | Dell 2135cn All-In-One Laser Printer

Check it using a laptop or desktop.

If they aren't listed there then something went wrong with your order.

If they are listed in your Kindle library, you need to turn on your Kindle and connect it to wi-fi or 3G. Your Kindle should then automatically download the new books. If it doesn't, touch Settings and select *Sync and check for new items*. Make sure the Kindle you want to download the books to is listed as your default Kindle if you have more than one so new books will automatically download to it once it's connected.

Apr 24, 2015 | Amazon Kindle

### Cost on replacing the stater on my 2003 Honda

cost over the phone or on the internet,we are not
in the 1950's, when shops went to a book for a price,
then lost money doing the work at that price

That is not possible & never has been

No idea what country your in or what different
shops charge or what is involve to change it

No parts get replaced until they are tested & fail a test

May be nothing wrong with the starter

What if your had a price,then what,the job still has to be done
& you have to pay

Sep 29, 2014 | 2003 Honda Accord

### I need help putting my 1990 honda elite carburetor back together

Buy a rebuild kit for it- has all the gaskets, rubber or composite-made parts, and a few most-wear-prone pieces. But always included with the kit is a sheet of paper showing a blown-up or "exploded" view of the carburetor, and every part is numbered. Starting at 1 and going to often about 100. Or 80 maybe for a small carburetor. But the key is to dismantle it in order from 1 to the end. And to put it back together in just the reverse order.
That's what you have to do. The only way to get it all back together, and the right jets in their proper place, and not spend time putting something on and then having to take it back off because something else went in or on first, you want it to work right after all the frustration and time you spent on it. You won't know until it is bolted back on and the engine started and you have test driven it...you won't know if you did it right until that moment. So get that sheet of paper. Most all carburetors show the last part is the throttle valve body assembly-the base of the carburetor. The obvious place to start. Follow the order back, by the numbers, at one you are done. A rebuilt carburetor!

May 22, 2014 | Cars & Trucks

### Hi i have a 40 samsung tv.My grandson Accidently hit the screen with the wii remote ,How much would it cost to repair ??

Just to order a replacement panel will cost you \$150-\$200 for a used panel. New panels will probably be double the price of a old one. This doesn't include labor costs. Typically most experts suggest that if repairs will cost more than half of the price of a new TV set, you do not repair you replace.

Oct 13, 2012 | Samsung Televison & Video

### My dog chewed the power cord off my FPOS1800A-08 submersible pump, From whom do I order a new cord.

After searching, a clear answer was found ... if the cord replacement exists, it costs a lot.
Flotec has a contact-us form that requires your personal information
http://www.flotecpump.com/

That being said, flotec FPOS thermoplastic sump pumps have pdf parts list.
Parts list shows cord as replacement part.
http://www.flotecpump.com/
However, I don't see the FPOS1800 listed
http://www.flotecpump.com/pdf/FP0S6000A_08ReplacementParts.pdf

Flotec sell sheet shows FPOS1800 but does not show parts
http://www.flotecpump.com/pdf/Pg_6_2006.pdf

Website below sells flotec parts
http://www.pumpagents.com/FlotecPumps/flotec-pump-part-list.html
Random cordset price-check shows \$46 for a cord
Another cord was \$80
Another cord was unknown

Nov 14, 2010 | Flotec FP0S2400A-03 1/3 HP 2,500 GPH...

### Formulate Sheets for Price Analysis

This achieved like this.
In sheet one there is cell where you input discount percentage say for exaple it cell B5. Now this cell needsto formatted to percentage(click location B5 and then right click and select format cell .On number tag select percentage). Also in cell C5 put 75 and it will write 75% as it formated to show percentage.
Let us look at one product and then you can apply the same principle to all products.
Go to sheet2. This will contain full price in one cell and discount price.Let us say full price is in location B10 and you want the discounted price in C10.
Now if the discount is 30 % then obiously you are paying 75% of full price.
To display discount price in sheet2 at C10, you need to enter this formula in C10
C10*sheet2!\$B\$5
Now as soon as your the discount changes C10 will change to reflect the discount rate.

Sep 03, 2008 | Microsoft Excel for PC

### Help I dont know mutch of excel

If I am doing price analysis and have List Prices but want to formulate the whole sheet that it will calculate 30% of prices to give me trade prices

How can I do this

Sep 02, 2008 | Microsoft Excel for PC

#### Related Topics:

37 people viewed this question

Level 3 Expert

Level 3 Expert