Spreadsheet guru needed

[onebob]

I am not skilled at writing formulas and would welcome some help. What i want to be able do is enter a number into say C5 and have that number populated to say 20 other scattered cells in the matrix i will create..
Can it be done ??

[Classic88]

I am not skilled at writing formulas and would welcome some help. What i want to be able do is enter a number into say C5 and have that number populated to say 20 other scattered cells in the matrix i will create..
Can it be done ??

I think a simple "=C5" in the destination cells should do the trick.

[onebob]

Sadly no.....[emoji17]says that formula cannot reference.

[dirvine]

Try =+C5. Although =C5 works for me.

[p38arover]

Sadly no.....[emoji17]says that formula cannot reference.

It should work (I just tested it). Did you leave out the quotes? Is C5 in the same spreadsheet?

[onebob]

Yup, left out the quotes. Shoulda said up front that i'm not using excel but Apple Numbers. I have used excel formula's before as a guide to successfully build a lottery checker in Numbers. So if =C5 works in excel then i need to tinker a bit more i guess...

[onebob]

It's got something to do with setting the cell reference ie sum or product or the like.... I just tried product but no joy [emoji37]

[Tombie]

Bob are you willing to send me your sheet?

[Tombie]

Bob this sheet works....

just a hack to test linking etc.. Download it and change extension from .xlsx to .numbers as this forum wont allow a numbers file format.

[onebob]

Thanks a million Tombie, i have downloaded it and will have look sometime today [emoji1360]

[NavyDiver]

excell has relative and absolute references '$' locked the coding $A$1 lockes to cell A1 so code $A$1*B1 spilled down four cells would then be $A$1*B4

=sum( can also be needed though that viaries with versions of XLS. =Sum($A$1*B1) and so on

Have fun and post your sheet if it fails for us to play with for you

[onebob]

DOH!!
Tombie I worked it out from your examples - I knew i was overthinking it. Thanks to other posters well. BTW Classic88 =C13 does work too but only if i put it in right cell [emoji849][emoji5]