I need to add a value ($2.95) to every cell containing an integer on my spreadsheet. What formula would I use for that lol.
I need to add a value ($2.95) to every cell containing an integer on my spreadsheet. What formula would I use for that lol.
whats the layout and by integer do you mean 1,2,3 or any number like 1.30?
if its just a column say put 2.95 in a spare cell copy it select your range of numbers then paste special ADD
Last edited by martindwilson; 12-07-2012 at 10:29 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
The numbers are dollar amounts. This is what it looks like, lol. Thanks for your help! ^_^
excel.png
Hi Peterguy
Assuming data in A1 maybe!!
Formula:Please Login or Register to view this content.
cant see a thing in that image!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks