Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/12/2005(UTC)
Posts: 141
Location: Brooklyn,NY
|
Since I've seen a few people here that seemed to be proficient in excell
I thought I post it here before I go crazy searching the internet(which I did ,but not extensivley).
I'm trying to condense this spreadsheet that I put together,and
I need to eliminate a few columns by subtracting ie:(cell c2-d2)
and multiply the answer by .8.
I know I could get a cell to subtract with the following:{=c2-d2}
but i cant get it to multiply the result by .8 .The formula:{ (c2-d2)*.8 or (=c2-d2)*.8} does not work.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
hey sport...... g seems to have the best experience in excell.... this might work..........h
[code:1:b3eb9ef0c5]=PRODUCT((C2-D2),0.8) [/code:1:b3eb9ef0c5]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Is your formula =C2-D2 working? Does it produce a result?
I will take a guess and say the problem MIGHT lie in that cells C2 and D2 (one or both) might not contain NUMERICAL information. Two ways around this:
force the cell contents to be numbers by using cell formatiting, or
take the value of the cell if it contains textual information, i.e =(Value(C2)-Value(D2))*0.8
Let us know if this fixes the problem.
If you need more helps, ask
wabbit :D
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/12/2005(UTC)
Posts: 141
Location: Brooklyn,NY
|
Hey guys,
Thanks a lot I got it resolved with the above formula Quote:{Code:
=PRODUCT((C2-D2),0.8) } I was getting a result with the formula =C2-D2 but I wanted to bypass
this and go straight for what I wanted to save room on spreadsheet,instead of having to have a column for each.
I was working on this for a few hours and just couldnt get it to work .Thanks again. =D>
sorry about the smiley face in the formula -thought maybe {} would get rid of it but didnt.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
