Results 1 to 11 of 11

Help With The IF Function

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2009
    Location
    Lethbridge, Alberta, Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Help With The IF Function

    Hi all,

    I am looking for a little bit of help with a problem I am having. I am developing worksheet for the purpose of calculating Short Rate earned premiums. I have the majority of what I need figured out but I am haveing some trouble with the IF function. What I am trying for is something like:

    IF(C4=D4,70,0)

    But for some reason the fuction won't work for me with "=", i can get it to work with ">=" or "<=" but if I use "=" it continues to come up false even when its true. Any insight would certainly be appreciated. Thanks.

    Last edited by will.osmond; 08-29-2009 at 05:52 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1