Nested If

 

Discussion List

  • Nested IF FIND formula
    In Formulas and Functions
    I am trying to use an IF/FIND formula to validate a columns value to make sure it is a "valid" email address. It must contain "@xxx.com". I was able to find a solution to work with that scenario. However, I have discove…
    Accepted
    28 5
    Accepted Answer 28 views 5 comments Most recent by Jeff Reisman Formulas and Functions
  • Nested IF error
    In Formulas and Functions
    Can someone tell me where to place the last [value false] information on this very long formula? I'm having issues with it always showing the last true value (20) for the false values (School Missing) or an error message when I move it to…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Christina Lam Formulas and Functions
  • Nested Criteria error only for one row
    In Formulas and Functions
    Hello Community, I have a column formula that works fine for every row except one. This particular row is not any different that I can see from the others. I apologize for the length of the formula, I will do my best to isolate and breakd…
    Accepted
    42 3
    Accepted Answer 42 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Nested if statement not working, am I doing the formula wrong or is it not working correctly?
    In Formulas and Functions
    Hi all - I am trying to do a nested if statement for an approval chain but I can not get it to return a value different than #UNPARSEABLE. Can someone check my formula and tell me where I am going wrong? =IF([Cell 1]@row = "No", …
    Answered - Pending Review
    23 1
    Answered - Pending Review 23 views 1 comment Most recent by Bassam Khalil Formulas and Functions
  • Voting using Symbols Formula
    In Formulas and Functions
    I want to collect "votes" from multiple voters (columns Voter 1, Voter 2, Voter 3, Voter 4, Voter 5, Voter 6) using RYG Balls in a sheet. Each row represents an item that is received through a form that must be voted on. I hav…
    Accepted
    53 2
    Accepted Answer 53 views 2 comments Most recent by Jessica Chandler Formulas and Functions
  • How to create a Nested IF formulae for the detailed below :
    In Formulas and Functions
    If Type is Option A, then Target Completion is Assigned Date + 7 if Type is option B, then Target Completion is Assigned Date + 15
    Accepted
    13 2
    Accepted Answer 13 views 2 comments Most recent by Gaurav Chauhan Formulas and Functions
  • Nested IF-AND-OR within the same cell...
    In Formulas and Functions
    Hi All, I am trying to automate a cell based on the status selected in 5 different cells (all within the same sheet) For Eg., First 5 columns has the following Statuses. Complete Incomplete In Progress Sick Dropout Cancelled Scheduled Con…
    Answered - Pending Review
    4 2
    Answered - Pending Review 4 views 2 comments Most recent by Suresh Seetharaman Formulas and Functions
  • Formula
    In Formulas and Functions
    Having difficulty with a formula setting task state (Not Started, In Progress, Complete, On Hold) depending upon how the columns on either side are set - Status/RYGB and % Complete. =IF(AND([email protected]=“B”, [% Complete]@row =1),"Compl…
    Accepted
    22 3
    Accepted Answer 22 views 3 comments Most recent by Bassam Khalil Formulas and Functions
  • IF formula to Assigned To
    In Formulas and Functions
    I am having trouble trying to figure out the formula based on the example: If the ISSUE TYPE is PTO, then assign it to XXXX. I have one column labeled "Issue Type" with a dropdown selection, and the other column labeled "Ass…
    Answered - Pending Review
    26 1
    Answered - Pending Review 26 views 1 comment Most recent by Mark Cronk Formulas and Functions
  • Nested If Formula
    In Formulas and Functions
    Could someone please help me with this IF formula? Much appreciated! =IF([Total Individual Miles]1>350, "Five", IF(Total Individual Miles]1 <= 50, "One", IF(AND([Total Individual Miles]1 >50, [Total Individual …
    Accepted
    33 2
    Accepted Answer 33 views 2 comments Most recent by Vanessa Sandom Formulas and Functions