Comparisons

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

Guest

I would like to compare a numerical value in one cell to the numerical value in the second cell and receive a message in the thrid cell

Cell A1 has a value of 15
Cell B1 has a value of 15
Cell C1 with the formula and answer

I would like a formula to give me a text string and if the comparison is not true then nothing
An example formula that I have used i
IF(A1=B1,"PAID",""

The formula works with <> when the "less than" and "greater than" sign is inserted and the appropriate less than or greater than value is inserted in the second cell

If the cells are pure numbers it works.

However, I have links and other formulas that generate the numerical value in the first cell that the second cell compares to
The second cell is a pure numerical entry

I cannot find a formula set up that works with the equal sign

Answer through the group

Grazie,
 
Maybe the values generated from the formulas are not equal to what you
enter, try

IF(ROUND(A1,2)=B1,"PAID","")

the above is for 2 digits, if no digits like in 150 use

IF(ROUND(A1,0)=B1,"PAID","")




--

Regards,

Peo Sjoblom

Maurice said:
I would like to compare a numerical value in one cell to the numerical
Click to expand...
value in the second cell and receive a message in the thrid cell.
Cell A1 has a value of 150
Cell B1 has a value of 150
Cell C1 with the formula and answer.

I would like a formula to give me a text string and if the comparison is not true then nothing.
An example formula that I have used is
IF(A1=B1,"PAID","")

The formula works with <> when the "less than" and "greater than" sign is
Click to expand...
inserted and the appropriate less than or greater than value is inserted in
the second cell.
If the cells are pure numbers it works.

However, I have links and other formulas that generate the numerical value
Click to expand...
in the first cell that the second cell compares to.
 
Try this.........

=IF((A1*1)=(B1*1),"PAID","")


Vaya con Dios,
Chuck, CABGx3


Maurice said:
I would like to compare a numerical value in one cell to the numerical
Click to expand...
value in the second cell and receive a message in the thrid cell.
Cell A1 has a value of 150
Cell B1 has a value of 150
Cell C1 with the formula and answer.

I would like a formula to give me a text string and if the comparison is not true then nothing.
An example formula that I have used is
IF(A1=B1,"PAID","")

The formula works with <> when the "less than" and "greater than" sign is
Click to expand...
inserted and the appropriate less than or greater than value is inserted in
the second cell.
If the cells are pure numbers it works.

However, I have links and other formulas that generate the numerical value
Click to expand...
in the first cell that the second cell compares to.
 
Peo
Thank you for the assistance. I found a value in the fourth decimal position which made one value unequal to the other.
 
Thank you for the information. However, because of the value in the fourth decimal position the formula is not the solution. Peo's rounding formula gives the desire results.
 
Back
Top