Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Zabo04 Your Own Question

Zabo04, Computer Enthusiast

Category: Microsoft Office

Satisfied Customers: 283

Experience: Experienced in Word, Excel, Access, Powerpoint, and Outlook.

58597962

Type Your Microsoft Office Question Here...

Zabo04 is online now

I need to configure a formula in Excell 2007/2001 that will

This answer was rated:

★★★★★

I need to configure a formula in Excell 2007/2001 that will take a number (1-10), assign a value of 80 as a baseline for the number '1' and increment that value by 20 if the number is XXXXX another 20 if the number is XXXXX etc.

The end result needs to be 80, 100, 120, 140, 160...for the value of 1,2,3,4 and 5...

If that number where in a cell (say cell A4), the formula would be =80+(A4-1)*20

Zabo04 :

for 1 in A4: 80+(1-1)*20 = 80

Zabo04 :

for 2 in A4: 80+(2-1)*20 = 100

Zabo04 :

If no cell specifies the number then you could use a different method. If this column (say column A) of your table starts at row 4, so A4 is the first cell, enter 80 into cell A4.

Zabo04 :

In cell A5 enter =A4+20

Zabo04 :

copy and paste the formula in cell A5 down the entire column and every row will increment by 20 from the previous row

Customer:

Hi Zabo04,

Customer:

You really know this well. Thank you for getting me started with the right answer and approach.

Customer:

Thank you,

Customer:

Chuck

Zabo04 and other Microsoft Office Specialists are ready to help you