Consulting

Results 1 to 4 of 4

Thread: Receiving a False in ;If Function

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Jun 2007
    Location
    Brighton, TN
    Posts
    2
    Location

    Receiving a False in ;If Function

    The following function, for some reason, will not work with certain numbers:

    =IF(AND(Totals!S5>=1,Totals!S5<=1.67),"Minor",IF(AND(Totals!S5>=1.68,Totals!S5<=2.35),"Moderate",IF(AND(Totals!S5>=2.36,Totals!S5<=3),"Severe")))
    This is a simple function but when the value in "Totals!S5" is 1.67 or 2.35 it returns a FALSE in the cell. For the life of me I cannot figure out why. Is there anyone who could help me with this. (I know the function may be set up really bad and my lack of knowledge may be the problem). There is never a time when the value should be false because the numbers in "Totals!S5" are always between 1 and 3.

    thanks
    Last edited by Aussiebear; 05-12-2025 at 02:09 PM.

Posting Permissions

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