I need a specific formula in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Educational use:
Using excel to set pupil targets. Each target level is subdivided into three
sub levels.ie Level 3 a,b,c; Level 4 a,b,c etc. Is there an excel formula
that could automatically raise a level/sublevel by a margin of two, ie raise
a level 3b to a 4c etc?
Any help would be appreciated
 
Hi

With Level 3c in J5 and number to be added (2) in K5
=--(LEFT(J5))+CODE(RIGHT(J5))+K5-99&CHAR(M5+K5-1)
will work for the specific example, but not as a general result.

If your tables is set out as
J1 3a
J2 3b
J3 3c
J4 4a
J5 4b
J6 4c

Then with your uplift in column K
=OFFSET(J1,K1,0)
will work

If your list is descending i.e. from 4c down to 3a then
=OFFSET(J1,K1*-1,0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Really need some help with a tricky formula 8
If formula help needed 5
average using two criteria 2
Group rows (or hide rows) like in MS Project 2
IF command, limit to number of entries? 2
Teaching Sub-Levels and Excel Nightmare 2
CORREL formula with criteria 2
look up, match index? multi variable formulas 1

Back
Top