Probably a simple Excel question

  AndySD 21:38 11 Feb 07
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 07

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 07

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now