getting a value of 0 when i am looking for 2000 or 3000

[firefightnlife]

this is my whole string of code, the bottom is the trouble i am having, it gives me a return value of 0 when i would want it to be 2000 or 3000. this is an input amount. the code in red is where i am having trouble

Please Login or Register  to view this content.

[p24leclerc]

I think that your problem comes from the fact that your are creating a CIRCULAR formula. Is it an error? Do you really want cell B4 formula to be B4*1 or B4*B3?

[Firefly2012]

Hi

You would get a circular reference as the formula will refer back to the cell into which it is entered. Is this what you want (eg if you have iterations enabled) or do you want a simple value in B4 (without the formula)?

[firefightnlife]

when starting this i thought it was going to be easy, was i wrong. i initially had "=3000*b3" in cell b4. however 3000 is not a constant it may be 2200 2500 3500, what the value represents is the average production and what b3 represents is the number of crews. so what i am looking for in b3 and b4 is to be able to input into b4 lets say 3000 and b3 lets say 1. but if i need 2 additional crews to go then my total in b3 would be 3 thus when i enter 3000 in b4 the calculation will show the value 9000 in b4, and when i drop the crews back to 1 crew the original value of 3000 will again be represented in b4.

[firefightnlife]

not sure if this may help so this code will work but b5 is an average per week and draws from the b4 and the days/week worked in b6

[MrShorty]

so what i am looking for in b3 and b4 is to be able to input into b4 lets say 3000 and b3 lets say 1. but if i need 2 additional crews to go then my total in b3 would be 3 thus when i enter 3000 in b4 the calculation will show the value 9000 in b4, and when i drop the crews back to 1 crew the original value of 3000 will again be represented in b4.

Or, put another way, you want a cell (B4) to contain both an editable constant (3000) and a formula (editable constant*B3).

IMO, this is bad spreadsheet programming. A spreadsheet cell works best if it contains either an editable constant or a formula. So, here's how I'd probably set this up:

B2 contains the editable constant (3000)
B3 contains the multiplier (3)
B4 contains the formula =B2*B3.

[firefightnlife]

this is how far i have gotten its just i cannot drop the value back to 1 in b3 and the original input come back

Please Login or Register  to view this content.