if function and conditional formatting

I have 2 colums in a spreadsheet.
The first column will contain a figure calculated by a simple formula (addition of 2 other cells)
The second column will be blank so that the user can fill in the value.

This is for each row in the 2 columns

I am trying to use an If formula to compare the 2 cells. But according to excel the cells are not equal even when the values are identical. I want the formula to create the word "PAID" in the next column if the first 2 colums are equal, and the word "UNDERPAID", if the second column is less than the first. Also if "UNDERPAID", I need it to calculate the difference between the first and second columns and put this in the same block as "UNDERPAID"

Also I would to make Paid in a green box and underpaid in a red box

Thanks
In your one it works just fine, but im my spread sheet, what should be "Paid" is just blank

Originally Posted by Tziggy

Thanks
In your one it works just fine, but im my spread sheet, what should be "Paid" is just blank

Is your spreadsheet setup the same as mine, i.e Column A as what should be paid, Column B as what has been paid and did you copy the formula in exactly?

It might be easier if you could attach a sample spreadsheet so I can have a look. I have a feeling it might have something to do with the column setup.

Ok here is the file that Im working on
Underpaid works fine, just not the paid one

by the way, what does CONCATENATE mean?

Originally Posted by Tziggy

Ok here is the file that Im working on
Underpaid works fine, just not the paid one

by the way, what does CONCATENATE mean?

I am just about to leave work so I will have a look when I get home.

Concatenate function allows you to combine two text strings. So if in cell A1 you have "Hello" and in cell b1 you have "there" you can concatenate those two cells to return "Hello there" in one single cell.

OK thanks
thank you for your assistance

Having a quick look at the spreadsheet, I would say the issue is with the fact that the Total Commission Due column all have an R prefix before the actual figure. The formula I suggested need both figures to be exactly the same if it is to work. This is the reason you are getting blank values. If the R wasnt there then it would work.

The only way I can think of would be to add another column and use the FIND formula for the values in the Total Commission Due to get rid of the R. The formula would work then.

I know this is a work around but unfortunately my Excel skills arent good enough to come up with a solution. Perhaps some of the senior members can help out.

Sorry mate.