multiply cell entry by 1.15 /within/ the cell?

Question

Level 1

108 points

multiply cell entry by 1.15 /within/ the cell?

would anyone mind just helping me figure out how i put a value in a cell and have it show up with an additional 15% markup? i am searching percent and i am getting help docs explaining how to enter percentages.

i /tried/ clicking on Numeric > PRODUCT and i get an entry that says "=PRODUCT(num-value, num-value) and i then tried changing the second num-value to "1.1.5" [i.e. "=PRODUCT(num-value,1.15"] but i get a red arrow stating "you must specify a number value for all arguments" and i am guessing that it wants to see a value in the first num-value.

is there a way to set this up so i can ENTER a number in the cell and have numbers bump it up 15%? i don't want to have a separate column for the 15% markup and it seems like there should be a way to have numbers do this in the cell. this way if i want to see the original number that was entered i can just click in the cell but the number that is visible is the value with the markup.

is there a better search term i should use in the help menu for this or maybe it is a different function?

THANKS

MacBook Pro, OS X Mavericks (10.9)

Posted on Oct 30, 2013 11:15 AM

Reply

Answer 1

hotwheels22 Author

Level 1

108 points

Oct 30, 2013 11:16 AM in response to hotwheels22

oops i mean - "i tried changing the second num-value to 1.15..."

Reply

Answer 2

Oct 30, 2013 11:23 AM in response to hotwheels22

HW,

Numbers has never supported the operation you want. A cell can contain either:

1) a formula OR

2) a value (or text)

You may make a feature suggestion to Apple using the menu item "Numbers > Provide Numbers Feedback".

if you want to inflate a cell by 15% then you can create a new column and enter the formula as needed.

e.g.:

Column B contains values I want to inflate by 15%. Column C has the formulas to perform this operation:

C1=B1×1.15

select C1, copy, select the column header ("C"), paste

If you want you can hide column C even while referencing it OR, you cam select column C, then copy, then just paste the values back over column using the menu item "Edit > Paste Formula Results"

Reply

Answer 3

hotwheels22 Author

Level 1

108 points

Oct 30, 2013 11:35 AM in response to Wayne Contello

god wayne. thank you for the mission critical and timely help!

so i have created a second column "markup" (column C) and i have the original column "materials" (column B) and the third column C for markup now has the markup included in it which is the value i want.

now when i publish to pdf or save the spreadsheet i can hide column B and i am good to go i think.

can i just ask you about the last sentence? i mean, i need to retain all the original values in column B in case i need to change these but i wasn't sure if you were showing me something about copy and paste that i am missing.

THANK YOU THANK YOU THANK YOU

Reply

Answer 4

hotwheels22 Author

Level 1

108 points

Oct 30, 2013 11:52 AM in response to Wayne Contello

argh.

wayne.

when i am totalling up my spreadsheet horizontally i am seeing these "unneeded" numbers included in the totals to the right. so in your column 1 i am seeing 2.15 when i really just want to see the 1.15 and the other numbers i have /already/ totalled. if i HIDE the column i am still seeing this total as including this hidden column.

on the one hand i need to be able to edit these numbers and i also need to see the 1.15 total. but on the other hand i can't have them total out with the 1.15 because they are already /included/ in this number.

i have 800 rows of this.

is there a way to tell numbers to ignore this one COLUMN in the SUMS that i have already set up? i can't get my head around this because if i delete this column then i don't have access to it any more.

i guess if i finish the spreadsheet i can MOVE this column all the way to the left so that it is out of the way and it won't show up in the totals but i can still change entries and have them update in the 1.15 column is that right?

do you know what i mean...?

Reply

Answer 5

hotwheels22 Author

Level 1

108 points

Oct 30, 2013 11:56 AM in response to hotwheels22

OK. yeah, if i move it all the way to the right i still have access to the numbers and they don't get totalled...

THANK YOU WAYNE.

not sure about apple terms of service but i think when i catch a break i have to send you some sort of austin food gift card or something...

Reply

Answer 6

Oct 30, 2013 12:00 PM in response to hotwheels22

HW.

These forums as volunteer only. All of us mostly get satidfaction by helping someone. The point system is available for you to show your appreciation.

All the best.

Wayne

Reply

Answer 7

hotwheels22 Author

Level 1

108 points

Oct 30, 2013 12:18 PM in response to Wayne Contello

OMG. wayne, all.

can someone help me here.

i need to get these figures totalled with a 1.15 markup but i can't have them add within the horizontal sum.

is there a way to keep them removed from this by excluding them from this calculation so i can simply HIDE them but also not have them add in the sum? is there some functionality for this?

i am realizing that if i MOVE the row to a different part of the spreadsheet that i am not sure if i add ROW if this will update the cells that have been moved so they don't sum.

does anyone have any advice for this?

i also have to add three /other/ rows and add a percentage to THESE and this seems like it is going to get really messy and hard to follow if i can't keep them in the proper place.

IS THERE A WAY TO TELL NUMBERS TO EXLUDE A COLUMN FROM A HORIZONTAL SUM? i could just shade these columns so i know they are not getting added to the sums at the right but if i MOVE them so they don't get added it is really. really hard to follow...

anyone have any ideas on this?

Reply

Answer 8

Oct 30, 2013 12:24 PM in response to hotwheels22

Easy, HW. Put the focus on the column with the current figues. Option/Alt-RightArrow to create a blank column to the right. Let's say that the original values were in Column B. In the blank Column C write:

=1.15*B

Fill or Copy/Paste Down.

The marked up values will be in the new column. Check the calculation and confirm the results. Copy the new value Cells. Select the first old value cell and Edit > Paste Values. Delete Column C.

Jerry

Reply

Answer 9

Oct 30, 2013 12:26 PM in response to hotwheels22

HW,

rather than summing the whole row like

=sum(12:12)

which sums everything in row 12

use

=sum(A12:P12)

which sums the portion of row 12 from column A thru column P

Reply

Answer 10

hotwheels22 Author

Level 1

108 points

Oct 31, 2013 11:20 AM in response to Wayne Contello

ok. big thanks wayne. i will try and hunker down again and see if i can get this puppy finished.

Reply