Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Math Question
This is probably real simple for somebody, I just can't get it.
If I want 50% more of something in cell A1 I would Type: =SUM(A1)+(A1*50%) So if A1 is 14 the result would be 21...Perfect. But if A1 is (14) the result is (21) Not the (7) I wanted. Can anybody help??? |
#2
|
|||
|
|||
First, you SUM() function is superfluous. SUM(A1) returns A1.
I'm not sure why you think that positive 7 should be 50% of negative 14, but you can achieve your goal using =A1 + ABS(A1)/2 In article , "Mike" wrote: This is probably real simple for somebody, I just can't get it. If I want 50% more of something in cell A1 I would Type: =SUM(A1)+(A1*50%) So if A1 is 14 the result would be 21...Perfect. But if A1 is (14) the result is (21) Not the (7) I wanted. Can anybody help??? |
#3
|
|||
|
|||
No that is not what I think but when I want to add positive number to a
negative number I want to get closer to 0. "JE McGimpsey" wrote: First, you SUM() function is superfluous. SUM(A1) returns A1. I'm not sure why you think that positive 7 should be 50% of negative 14, but you can achieve your goal using =A1 + ABS(A1)/2 In article , "Mike" wrote: This is probably real simple for somebody, I just can't get it. If I want 50% more of something in cell A1 I would Type: =SUM(A1)+(A1*50%) So if A1 is 14 the result would be 21...Perfect. But if A1 is (14) the result is (21) Not the (7) I wanted. Can anybody help??? |
#4
|
|||
|
|||
Maybe.........
=IF(A1<0,(A1+(-A1*0.5)),A1*1.5) Vaya con Dios, Chuck, CABGx3 "Mike" wrote in message ... This is probably real simple for somebody, I just can't get it. If I want 50% more of something in cell A1 I would Type: =SUM(A1)+(A1*50%) So if A1 is 14 the result would be 21...Perfect. But if A1 is (14) the result is (21) Not the (7) I wanted. Can anybody help??? |
#5
|
|||
|
|||
Hi
but this is what the function does. Have you tried it? -- Regards Frank Kabel Frankfurt, Germany "Mike" schrieb im Newsbeitrag ... No that is not what I think but when I want to add positive number to a negative number I want to get closer to 0. "JE McGimpsey" wrote: First, you SUM() function is superfluous. SUM(A1) returns A1. I'm not sure why you think that positive 7 should be 50% of negative 14, but you can achieve your goal using =A1 + ABS(A1)/2 In article , "Mike" wrote: This is probably real simple for somebody, I just can't get it. If I want 50% more of something in cell A1 I would Type: =SUM(A1)+(A1*50%) So if A1 is 14 the result would be 21...Perfect. But if A1 is (14) the result is (21) Not the (7) I wanted. Can anybody help??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
basic pie chart question | Charts and Charting in Excel | |||
drop down list question | Excel Discussion (Misc queries) | |||
Compare Question | Excel Discussion (Misc queries) | |||
2 part question on averaging | Excel Discussion (Misc queries) | |||
Question on VBA | Excel Discussion (Misc queries) |