• 100% Satisfaction Guarantee

Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 32076
Experience:  Over 15 years of consulting to the IT industry
32989067
Richard is online now

There, I do have a very important question regarding a specific

Resolved Question:

Hi there, I do have a very important question regarding a specific operation I'm trying to program into apple numbers (in many ways similar to excel)... could you reply to this just so I know there is someone on the other end!! thank you
Submitted: 1 year ago.
Category: Computer
Expert:  Richard replied 1 year ago.
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.
I am here, what is the problem you are having with numbers?
Customer: replied 1 year ago.

Thank you Richard!

I'm currently designing a prototype platform for the UK solar industry. Over the last 4-5 months i've become reasonably proficient with numbers and understand the majority of the functions, and have been able to get around most of the problems... streamlining as i learn more... however... I can't seem to find a solution to the last hurdle.. which is as follows.

I want to store/lock/freeze a particular value in a cell.

ideally i'd like to use a 'stepper' in increments of 1, such that i can say, when the value of the stepper cell equals '1, 2, 3' etc... a value that is entered/calculated in another cell is then stored in another cell, and that this 3rd cell holds that value even when the stepper is increased... how the buggery does one do that!!!

Kind regards

resh

Expert:  Richard replied 1 year ago.
ok, you cannot assign values to another cell from within a cell, the change always has to be done in the cell itself.
But then in the other cell, use an if statement to set when the value should change.
Customer: replied 1 year ago.

sorry richard, that didn't help clear things up.

I'm sure you get some really 'slow learners' here... i'm happy to be treated like a very slow learner!!

the formulae (for cells A1, A2, A3 etc) i'm trying to write goes something like this..

if cell B1(stepper) = 1, then cell A1 = the current value in cell C1

however if cell B1(stepper) = 2, then cell A1 still equals the value of C1 when B1(stepper) equaled 1....and then cell A2 will be exactly the same formula except when B1(stepper) = 2.... and when B1(stepper) =3 A2 will still equal the value of C1 when B1(stepper) was 2... and so on and so forth...

Expert:  Richard replied 1 year ago.
ok, thats how I understood it.
What I am trying to say is you cannot assign a value FROM a Cell to another Cell.
So you cannot say from cell B1, Cell A1 =
You have to put a formula in Cell A1 itself. This is how it always has to work.
Do in cell A1 you would put if B1 = 1 then C1
The actual formula you put in A1 is
=IF(B1=1,C1,0)
Does that make sense to you?
Customer: replied 1 year ago.

lets say c1 = 200

a1 = IF(B1=1,C1,0) was my starting point... but if i increase the value of b1, then A1 = 0.

which isn't what i want... if i increase b1.. i still want a1 to equal 200... i want to freeze the value

Expert:  Richard replied 1 year ago.
ok, its always going to change depending on the statement, that you cannot do so you will have to manually set it then.
There is no way to freeze the value, only to have it set upon a set of rules.
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 32076
Experience: Over 15 years of consulting to the IT industry

What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.

• Kamil Anwar

Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >

Kamil Anwar

Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

James K.

Satisfied Customers:

93
Technical Director of IT Company

Jon-Tech

Satisfied Customers:

61
20 yrs: Computers, Networking

MikeW

Satisfied Customers:

53
32+ years Computer and Networking Experience

jamieratliff

Satisfied Customers:

21
Jamie has worked in the Information Technology field for over a decade.

TheDoctor

Satisfied Customers:

16
Experienced Software Engineer

Bill Fisher

Satisfied Customers:

1
Computer system design, networks, integration, general support.