[770]

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.

[Pluto3183]

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)

[DrJ]

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

[DrJ]

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