Using value from a cell that has formula

Karado58

New Member
Joined
Dec 20, 2009
Messages
7
=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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

jproffer

Well-known Member
Joined
Dec 15, 2004
Messages
2,643
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

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
=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

New Member
Joined
Dec 20, 2009
Messages
7
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
 
Last edited:

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196
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

New Member
Joined
Dec 20, 2009
Messages
7

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

New Member
Joined
Dec 20, 2009
Messages
7
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
 
Last edited:

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,514
Messages
5,596,610
Members
414,080
Latest member
penguin23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top