HowTo create an IF function....i think?

  • Thread starter Thread starter MackBeer
  • Start date Start date
M

MackBeer

I want to create a function that says something like this...IF C5=10 then A5=0, but if C5=11, then A5=10, and so forth,
up to C5=20 (yes..im creating a RPG form), also downwards to C5=1 then A5=-80


any ideas? tips? full blown solution...;p
 
Hi MackBeer!

Try using VLOOKUP.

Set up a table of values from 1 up to 20 in (eg) K1:K20. Against those
values in column L put the values that you want A5 to have if C5 has
the entry in K.

Then in A5:

=VLOOKUP(C5,$K$1:$L$20,2)

This looks up the value of C5 in the first column of the table and
returns the corresponding entry in the second column of the table.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
MackBeer said:
I want to create a function that says something like this...IF C5=10
Click to expand...
then A5=0, but if C5=11, then A5=10, and so forth,
 
Hi MackBeer!

Thanks for thanks is always appreciated. You'll find that VLOOKUP is a
common and easier way than attempting to use IF functions.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top