next »

[Please Support Us!]

Please Support Us!

Please help keep (=WDG=) alive

• Server rules
• Forum rules
• Join us
  
• Clan members
• About the clan
• Server stats
• WDG YouTube Channel
• WDG Downloads
• IRC Webchat

Steam groups:

• WDG community
• WDG clan group
• WDG Battlelog Platoon

Our allies:

• [NuB] TF2 clan
• Velocity Gamers Hub
• Destination Gamer

GoG Links:

• Wix Discord
• Wix IRC channel

TF2 Links:

• Official TF2 Blog
• TF2 Steam Forum
• The Fort 2

October 2025

Mo	Tu	We	Th	Fr	Sa	Su
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31
	Birthdays
Chaos (40)
	Upcoming Events
Upcoming Birthdays: Chaos (40)

[Millicent Bystander]

I need to work out some windows prices for work, as I am pretty clueless when it comes to Excel.

What I need to do is reduce the manufacturer's price by 62%

Add 50%

Add the glass price

Then do that 20,000 odd times.

Can anyone help?

[Chaos]

add 50%:
=sum("cell"/100*150)

add glass price:
=sum("cell"+"glassprice")

to do it more than once, click the little box in the bottom right of the cell and drag it down till you have it right....

hope that helped

[mark]

Didn't you ask this once before?

What Chaos said should work.

[Junta]

Just do "=(((cell * 0.38) *1.5)) + Glassprice) ?

Sorry - I didn't read the original question properly, so that's why I've edited this again

[Millicent Bystander]

Had to do something similar but less complicated

Edit: Thanks Junta, works a treat, now to see if my OCR reader is accurate or I'll have alot of tedious typing to do

[mark]

add 50%:
=sum("cell"/100*150)

Just do "=(((cell * 0.38) + ("cell" *1.5)) + Glassprice) ?

I think you should devide that into two cells:
one with the =cell*.38 and one with: =(newcell*1.5)+glassprice

=cell*.38 reduces the price to 38% of the price (should equal to retracting 62%)

[Junta]

add 50%:
=sum("cell"/100*150)

Just do "=(((cell * 0.38) + ("cell" *1.5)) + Glassprice) ?

I think you should devide that into two cells:
one with the =cell*.38 and one with: =(newcell*1.5)+glassprice

=cell*.38 reduces the price to 38% of the price (should equal to retracting 62%)

Yes, it is more readable in two cells

[Terror]

Should it not be:

=[CELL]*0.57+[GLASS]

I'm assuming it's an extra 50% after the reduction, not of the original value?

[r007]

If you want to get really fancy have the 62% reduction and 50% increase factors in seperate cells and reference them appropriately, so you can play with the values and not have to change 20.000 cells again. But whatever works I guess.

[Millicent Bystander]

Junta's first way works fine, thanks for the help though, getting a page done in the time it took to do 1 line.

[Terror]

Yeah, I missed that. Mine was the same as John's, just I combined the 0.38 and the 1.5.

[Junta]

I combined the 0.38 and the 1.5.

Feel free to correct me, but I'd have thought that was not possible as two separate % values required for calculation? I'm probably missing your point lol

[Terror]

I combined the 0.38 and the 1.5.

Feel free to correct me, but I'd have thought that was not possible as two separate % values required for calculation? I'm probably missing your point lol

(x*0.38)*1.5≡x*(0.38*1.5)

Therefore: (x*0.38)*1.5≡x*0.57


I don't see why that would be wrong, but I did (nearly) fail maths last year.

[claws]

It's associative that way, but I guess Junta thought he meant 0.38x + 0.50x which is two operations unless you simplify it to 0.88x

[Junta]

I combined the 0.38 and the 1.5.

Feel free to correct me, but I'd have thought that was not possible as two separate % values required for calculation? I'm probably missing your point lol

(x*0.38)*1.5≡x*(0.38*1.5)

Therefore: (x*0.38)*1.5≡x*0.57


I don't see why that would be wrong, but I did (nearly) fail maths last year.

Nothing wrong - a perfect explanation ty

Me being thick and not considering that as an option - I guess my work usually leads me to separate variables that might change.