How JustAnswer Works:
  • Ask an Expert
    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
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
A new question is answered every 9 seconds

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...

Any help with this is welcome.

Zabo04 :

is the number (i.e., 1, 2, 3, etc.) in a cell?

Zabo04 :

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 5 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions