comparing two cells

[Guest]

Hi Guys...

I would like to compare two colums ("A" vs. "B")in order to tell if the items in the corresponding cells in column B are smaller than in B. (for example, I would like some way of knowing if B30 was smaller than A30, etc.) I know a formula exists...maybe there is a way to highlight all the instances where B is smaller than A? Or perhaps some other similar way to accomplish what I am explaining....any help is appreciated!

 

[Audiojoe]

Hey there,

I believe the formula you'll need is:

=if(b30<=a30,"Specify an alert message","")

You could then conditionally format these cells to change colour or something if the argument returns true

 

[Audiojoe]

Of course this formula would only really be any good if it was numeric values you were comparing...

 

[Aladin Akyurek]

On 2002-02-25 06:23, Anonymous wrote:
Hi Guys...

I would like to compare two colums ("A" vs. "B")in order to tell if the items in the corresponding cells in column B are smaller than in B. (for example, I would like some way of knowing if B30 was smaller than A30, etc.) I know a formula exists...maybe there is a way to highlight all the instances where B is smaller than A? Or perhaps some other similar way to accomplish what I am explaining....any help is appreciated!

Assuming that your data starts in row 1,

in C1 enter: =(A1<B1)+0

Select all of the cells of C, activate Format|Cells, choose Custom, and enter in the Type box:

[=0]"No";[=1]"Yes"

The above gives you the choice to

=SUM(C:C)

in order to know how many A-cells are smaller than B-cells.

Alternatively, you can apply Conditional Formatting, e.g., to column A in order to color A-cells that are smaller than corresponding B-cells.