Hi,
I have the following data in a particular cell
=IF(C31>C34,(C31-C34),"$0.00")
I need to have the resulting figure rounded down to the nearest $250.
As much as I try, I can't seem to make it work. Have searched on-line, noticed the FLOOR function, but am more confused than ever..if that's possible.
Would appreciate any help with the correct formula.
Amy
I have the following data in a particular cell
=IF(C31>C34,(C31-C34),"$0.00")
I need to have the resulting figure rounded down to the nearest $250.
As much as I try, I can't seem to make it work. Have searched on-line, noticed the FLOOR function, but am more confused than ever..if that's possible.
Would appreciate any help with the correct formula.
Amy