Thread: Help With The IF Function

Thanks for the welcome!

I should have been more specific, its the value of cells c4 and d4 that should equal. And like I said it would work perfectly if i wanted it to be based on be greater then or less then but if the true or false is based on the values equaling then it always comes up false.

Ah ok well that was a little dense of me. I now understand the problem, the number being generated is a fraction, and even if I have the format set to show a whole number the IF function still sees the fraction and therefor the two can't be equal. It makes sense but also makes this more complicated. Is there anyway to get around that?

I'll explain in a litte more detail what I'm trying to do and hopefully you can point me in the right direction. I'm trying to create a form which will calculate earned insurance premiums based on a short rate table. This table determins the amount earned based on how many days into the policy term the cancellation is. I figured out how to calculate the number of days easily enough with the YEARFRAC function but as I said this generates a fraction. I take the fraction, multiply it by 365 to get the days. But because the number generated is not a whole number it makes it impossible to use the IF function to automaticly determine the % to be used. I'm stuck as to how to get around this problem without having to put in a field for the agents to reenter the generated whole number on the form. That works but its a little bit of an ackward way of doing it. Is there any way to get the generated day to be treated as a whole number?

Originally Posted by shg

You can round one or the other (or both) to the nearest whole number:

=IF(ROUND(C4,0) = D4, 70, 0)

This is exactly what I needed and indeed works perfectly to fix my problem. Thank you so much! Now its just a matter of data entry and asthetics.

Originally Posted by zbor

Can you please make thread [solved]?

Thread set to solved.