Excel Formula containing Value and Cell

[senators40]

Hi,

I have a cell in column A1 for 100

Cell C1 formula should be =A1+B1

However I would like it to be the value in cell A1 + the formula in B1

So the formula would be =100 + B1

If A1 were 150 the formula would be =150 + B1

Unfortunately the amount in A1 varies

Any help would be appreciated.

Thanks,

Jeff

 

[PHV]

As you asked in the VBA forum, here a VBA starting point:

Range("C1").Formula = "=" & Range("A1") & "+B1"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Hi,

Why would this not work ON THE SHEET?
[tt]
=A1+B1
[/tt]
What you stated, "However I would like it to be the value in cell A1 + the formula in B1," and your supporting example, "=100 + B1" is not consistent. =B1 returns the VALUE in B1, and NOT THE FORMULA in B1!!!

So =A1+B1, returns the VALUE in A1 plus the VALUE in B1. Nowhere is the FORMULA returned!.

If A1 ia 100, then THAT is what is used in the calculation.

If A1 is 150, then THAT is what is used in the calculation.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[senators40]

Thanks for the response. It worked very well

In my real scenario the amount in cell A1 is a result of another formula in another row, which may be sorted, moved or deleted so I wanted the number of whatever was in cell A1 and then add another number in another cell.

Thanks,

Jeff

 

[SkipVought]

"the amount in cell A1 is a result of another formula in another row, "

SO WHAT! It's the VALUE that is worked on, regardless of how it got there.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]