Jump to content

Anybody experienced using Apple iWork Numbers?


Neilp

Recommended Posts

Hi,

 

I'm looking for some help with a formula for a spreadsheet i'm producing. I'm limited in skill and got to a point where I need a spreadsheet to auto-accumalate. I'm unsure how to give text a numerical value, and then based on the text- a total to be accumulate per column as a numerical value.

 

Any help would be appreciated and if it helps I can forward a copy of the document i'm trying to produce.

 

Cheers

Neil

Link to comment
Share on other sites

Would a nested IF statement suffice, if the variety of text options in the column wasn't too broad?

 

All depends doesn't it, lots of ways to go about it, all right if you get the correct result :)

 

 

Sent from the golf club...

 

That's why Bill invented hidden "helper" columns :lol:

Link to comment
Share on other sites

Would a nested IF statement suffice, if the variety of text options in the column wasn't too broad?

 

All depends doesn't it, lots of ways to go about it, all right if you get the correct result :)

 

 

Sent from the golf club...

 

That's why Bill invented hidden "helper" columns :lol:

 

Help?

 

That is a new concept to me :p

 

 

Sent from the golf club...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...