Multiple Conditional Formatting or IF Functions

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

Guest

I am trying to create a report for a project that would do the following:
If a cell value = a certain number it would insert a number of my choice in the column next to it. Ex: If A2=50, then 75 would appear in cell B2. I need to be able to add lots of different conditions to the one cell, so that for each number it could equal, there would be a different number displayed in the cell next to it.

Does anyone know how to do this?

Thanks
 
If entered into B2, this would do what you initially asked:

=IF(A2=50,75,"")

However, if I understand you saying that,
<<"I need to be able to add lots of different conditions to the one cell, so
that for each number it could equal, there would be a different number
displayed in the cell next to it.">>,
then you would best create a list containing all the possible numbers, and
then use Vlookup formulas to return the matched up values.

For example, enter this in:
Col Y Col Z
25 50
50 75
75 100
100 125
125 150

Where Col Y contains a list of values that could be found in Col A,
And Col Z contains a matching list of values that you would want to be
displayed in Col B.

Then enter this formula in B2:
=VLOOKUP(A2,$Y$1:$Z$5,2,0)
And copy down as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I am trying to create a report for a project that would do the following:
If a cell value = a certain number it would insert a number of my choice in
the column next to it. Ex: If A2=50, then 75 would appear in cell B2. I
need to be able to add lots of different conditions to the one cell, so that
for each number it could equal, there would be a different number displayed
in the cell next to it.

Does anyone know how to do this?

Thanks
 
Back
Top