I need to see/find if there is a formula to add 5% to a column of prices that have gaps of cells. So the formula only applies to cells with data in them. The data can be in the next column and I can just Paste Special:Values over after conversion.
Attached is an example I am trying to figure out.
Thanks for any help!!
=IF(C2="","",C2*1.05)
Copied down in Column D.
I '<3' reputation. If I helped, click the scales. This will be helping an internal departmental competition with co-workers.
Reputation can be granted through the Scales Icon (for classic layout), or the little Star on the bottom of the post next to the blogging function for the new forum layout.
If you're not busy, and really feel down on life, read my excel blog which may or may not have contents.
Thanks you very much! Works like a charm!
Another approach without formula
Enter 1.05 in an empty cell
Copy it
Select your data
Right Click - Paste Special - Multiply - OK
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks