I have a column that you manually enter a number; either 0 (zero) or any number greater than zero.

I have another column with the formula of: =DAYS360(AN22,AQ22)

If the resulting formula figure/number is greater than the manually entered number then I want a third column to equal: $0.00
But if the resulting forumal figure/number is less than the manually entered number then I want that same third column to equal the following formula: =T21/U21*BF21

Math was never my strong point - I just can't figure it out.

Can anyone help.

If I understand you right, you need an if-formula in your third column:

=if("cell with your days formula">"cell with manually entered number";0;T21/U21*BF21)

(You also have to set the number format to currency so that it shows $0.00)

I believe this will work for you:

=IF(AK22>AJ22,"$0.00",T21/U21*BF21)

where AK22 = the 2nd column that holds the formula =DAYS360(AN22,AQ22)

and AJ22 = the manually entered field

Just change those two variables to the actual fields you are using for those and it should work. If not, let me know

Nice job pluto... these are the same formulas... just make sure not to use the quotes " in the actual formula.

You can use the quote to tell Excel enter exactly this... as in mine where it says to enter exactly $0.00 or NOT use the quotes and just use 0 (as in plutos) but be sure to format that manual cell to Currency with 2 decimals