Click here for important information about

Excel 2003 Formula for 2 words

March 2, 2011 at 21:56:49
Specs: Windows XP
Okay, the question is a bit weird. Let me try and explain. I work offshore on a moored platform and we occasionally "skid" around using our anchor chains. We have an excel sheet that we use, but it's really just for show. We input into the sheet the length of chain out now, the amount we need to adjust. Based on two words, "heave" and "slack", I am trying to create a formula either subtracts the adjustment length from the current amount (heave) or adds it to the current length (slack).

Any suggestions?

See More: Excel 2003 Formula for 2 words

March 3, 2011 at 06:22:35
Where do you enter the value for heave and slack?

If I were doing an excel sheet, I assume you date and time stamp each heave and slack?
a1 = heave or slack
a2 = amount

I would use an if statement. Look at a1, if heave, then cell = currentamountcell-a2, else cell = currentamountcell+a2.

Use a reference to the cell versus the absolute. :) You can then drag the formula down the sheet and it will repeat the pattern.

You could do this all in vba of course, but it depends on how complicated you need to make it or how you are placing the adjustments to the chain length.

Provide a little more sheet design information, and you may find a better resolution. :)

I'm still learning everyday.

Report •
Related Solutions

Ask Question