Can anyone assist with a formula/procedure that will fill in blank cells between two numbers, such that the percentage increases between cells increases linearly? For example, in cell A1 I have a value of 3400, and in cell J1 I have a value of 8000; I would like to fill-in cells B1 through I1 with values that increase at a linear percentage increase....i.e., 8% first cell increase, 12% next cell... etc until I get to 8000 in J1.
Hi jstanley- Not sure what you want. This steps each value up by a set amount based on the difference [J1-A1]. Paste in B1 and copy across:
Please Login or Register to view this content.
Last edited by leelnich; 02-21-2018 at 03:40 PM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks