Probably a simple Excel question

  AndySD 21:38 11 Feb 2007
Locked

But I am so tired toniht that its slipping away

How to set up a sheet with percentages in B(4%) C(4.25%) etc and the ammount in the A column, A2(100), A3 (200) so that B2 will show 4 and A3 will show 8 etc

Andy

  VoG II 21:51 11 Feb 2007

With:

B1 set to 4%, C1 set to 8%

A2 contains 100
A2 contains 200

In B2 enter

=$A2*B1

Hover the cursor over B2, when it turns into a + drag to right and down to copy the formula.

  AndySD 22:55 11 Feb 2007

Thank you

Its all up and runnung..... but my brain is still in ultra slow...lil

Andy

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Best of the Grad Shows 2017: University of the West of England (UWE)

Best value Mac: Which is the best £1249 Mac to buy

Les meilleures GoPro 2017