Using value from a cell that has formula

[Karado58]

=G42+G36
=K42-K36

I would like to take the date results from each of the above cells, subtract it from each other and make it appear on a third cell.

I tried this =(G42+G36)-(K42-K36) but it just adds them together.

Thank you
-Joseph

 

[jproffer]

If you have those 2 formulas in other cells already, just add the result cells together.

A1=G42+G36
A2=K42-K36

you could use =A1+A2

oops I mean =A1-A2

 

[barry houdini]

=G42+G36
=K42-K36

I would like to take the date results from each of the above cells, subtract it from each other and make it appear on a third cell.

I tried this =(G42+G36)-(K42-K36) but it just adds them together.

Thank you
-Joseph

Hello Joseph, welcome to MrExcel

That should work, assuming that the date created from G42+G36 is later than the date created by K42-K36. Make sure that the result cell is formatted as general.

If that still doesn't work then.....what result do you get, exactly. What do you expect?

 

[Karado58]

Hello Joseph, welcome to MrExcel

That should work, assuming that the date created from G42+G36 is later than the date created by K42-K36. Make sure that the result cell is formatted as general.

If that still doesn't work then.....what result do you get, exactly. What do you expect?

They are formatted as Curency.

I get the totals of both cells

OK...
the formula in G38 is =G42+G36
it returns a value of $2.62
the formula in K38 is =G42+G36
it returns a value of $2.49

I want to subtract K38 from G38....should be 0.13

 

[barry houdini]

ADVERTISEMENT

I want to subtract K38 from G38....should be 0.13

Try

=G38-K38

 

[Weaver]

I'm assuming when you said 'date' in your first post, you actually meant 'data'.

Having said that, I'm seeing some inconsistency in the second formula, as you first said it was

=K42-K36

then went to

G42+G36

in your most recent post

 

[Karado58]

ADVERTISEMENT

If you have those 2 formulas in other cells already, just add the result cells together.

A1=G42+G36
A2=K42-K36

you could use =A1+A2

oops I mean =A1-A2

I did that but I get an addition, not subtraction

 

[Karado58]

i'm assuming when you said 'date' in your first post, you actually meant 'data'.

Having said that, i'm seeing some inconsistency in the second formula, as you first said it was

=k42-k36

then went to

g42+g36

in your most recent post

=g42+g36
=k42-k36

yes data

the formula in G38 is =G42+G36
it returns a value of $2.62
the formula in K38 is =K42-K36
it returns a value of $2.49

I want to subtract K38 from G38....and appear in cell F49...should be 0.13

 

[barry houdini]

So you tried this formula

=(G42+G36)-(K42-K36)

and got $5.11?

That doesn't make sense if G42+G36 = $2.62 and K42-K36 = $2.49

What's in the 4 source cells?

 

[Karado58]

so you tried this formula

=(g42+g36)-(k42-k36)

and got $5.11?

That doesn't make sense if g42+g36 = $2.62 and k42-k36 = $2.49

what's in the 4 source cells?

g42 = 0.01
g36 = $2.61
k42 = 0.01
k36 = $2.50