Recent content by jools230575

Hi there I am a novice user on Excel and wondered if someone could help? Basically what I would like to be do is the following: 1) From the attached excel file work out how mnay people have each product, which is in Column B 2) From there, work out how much is each product, so for instance...

I think I will ask for help somewhere else. Your time has been appreciated, but I don't appreciate the "how old are you" comments!

Yikes! OK. I did wonder if there may be some kind of "IF" statement involved somewhere along the line. That is very near to what I'm after, but what I need is more simpler. Is there anyway to do it as originally indicated? Curiosity, looking at the formula I can see what is going on, but what...

OK, attached is a quick example. I want to be able to: 1) enter a value into B1. 2) this value is then split out automatically in B3, B4, B5 and B6. I am able to do Column C as you see from the spreadsheet. Hopefully this makes it a little clearer:) Jools

OOps, yep. I do want something calculated between £500,000 and £1,000,000. The formula would be the similar to one of the other examples.

Hi there I need some help from some kind folks if possible please. I use Excel, but only to a very basic standard, i.e. just formulas and maybe some charts. What I would like to be able to do, and I don't know if this is possible, is this: 1) Enter into a cell a total amount, say...