'if' 'and' formula

[mystic342005]

I am trying to get the payment type to put "partial" if the BALANCE is < COMMISSION AMT(in the first row for that customer), and put "Final" if the BALANCE = 0.

It looks like it works in some instances, but not all.

Please see attached copy of the spreadsheet.

(I have modified each group of payments per customer to reflect the proper row for the commission amount).

Thanks !!

[protonLeah]

When I reformatted your numeric cells to show more decimal places (15), I saw that two balances were not actually zero for some reason; so I used the round(#,2) function on column H and it corrected the payment type.

[mystic342005]

Thanks so much !!! That worked perfectly.

I don't understand, though, how it ended up with such a weird number of decimal positions, since all the amount columns were formatted as 2 decimal place numbers...


Thanks again.

[BigBas]

Thanks so much !!! That worked perfectly.

I don't understand, though, how it ended up with such a weird number of decimal positions, since all the amount columns were formatted as 2 decimal place numbers...


Thanks again.

When you use the FORMAT NUMBERS feature, and choose decimal places, it only changes how the number is displayed. So, the number 1.0035 would show as 1.00, but Excel stores it as 1.0035. The ROUND function forces the number to actually change to 1.00. Hope that clears it up for you (and others with the same problem).