Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a sheet that has to columns of numbers. I would like to have a
formula that looks at the numbers in both columns (1 row at a time) and gives me a result in column 3 based on that comparison. Column A will be one of the following values= 0,1,2,3,4,8 Column B will be one of the following values=2,3,8 Here is my criteria for comparing the two (assuming I am comparing A1 and A2 first, with the result being in A3): If A1=0 or 1 then A3=1 (no comparison needed on the first 3) If A1=2 then A3=3 If A1=8 then A3=5 If A1=3 or 4 and A2=2 then A3=4 If A1=3 or 4 and A2=3 then A3=5 I can write out the specifics of what I need to compare.. I just have no solid idea of how to put that into an Excel formula. Any help at all is greatly appreciated. Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Comparing values and retrieving values in Excel!!!!!! | Excel Worksheet Functions | |||
Macro Help Needed: Comparing cell values and deleting rows | Excel Discussion (Misc queries) | |||
Comparing multiple cell values | Excel Discussion (Misc queries) | |||
Comparing cell values then labeling them based on comparision | Excel Discussion (Misc queries) | |||
Counting values and comparing them to a single cell | Excel Discussion (Misc queries) |