Excel help
Computing and PC help and advice, programming, games, digital audio, mobile phones and electronic miscellanea.
| Announcements | Posted on | |
|---|---|---|
-
- Reputation:
- Thread Starter
- Junior Member
- Location: Liverpool
- Posts: 31
Excel helpI've been trying for months to find a formula in an excel spreadsheet
in cell A1.
I'm want a formula for a range of numbers, these are:
11 to 17 with the same value as 2
18 to 24 with the same value as 1
I have tried SUMIF but getting knowhere!!!!!
HELP HELP
I don't want to do these individualy.
sent your formula for me to try out to:
URGENTLast edited by Illusionary; 13-07-2012 at 21:47. -
- Reputation:
- Exalted and Worshipped Member
IF possible could you upload the spreadsheet or create an example spreadsheet with similar figures?(Original post by dickie_doc)
I've been trying for months to find a formula in an excel spreadsheet
in cell A1.
I'm want a formula for a range of numbers, these are:
11 to 17 with the same value as 2
18 to 24 with the same value as 1
I have tried SUMIF but getting knowhere!!!!!
HELP HELP
I don't want to do these individualy.
sent your formula for me to try out to:
URGENT
