and if or

So, the goal is to find 3 criteria within column D, if column P ( month ) matchs another column on a different tab, count the number on column J The old formula that was used is, "=IFERROR(IF(OR($C5923="Renewal",$C5923="Client Implementation"),0,J5923),"-")" since our CRM has been updated...

Hi! I am trying to make a formula where the longest word in a range from a different worksheet, is reflected in the same cell where I create the formula. For example, Cell A4 should have the formula and the Range would be located in a Worksheet labeled Descriptions Cell A4 would show the...

Hi There, Does excel accept OR & AND within the same if statement? I'm trying to state the following: =IF(OR($A$2="YES",$A$2="MAYBE",AND($A$4="English"),"Level 1","")) Would anyone be able to provide a sample of an IF statement using OR & AND? Thank you!

I don't even know if this is possible. I have a cell that is percentage of a task completed. It counts the yes's in a range and returns percentage complete. When all of the cells are marked “Yes” it says 100%. Original formula for Over All %: =COUNTIF(C10:C33, “Yes”)/COUNTA(C10:C33) Now...

Hi, I have a complicated nestled If string which isn't working - does anyone know why? =(IF(OR(((F6-I7)>O3),((F6-I7)<K3)),(IF((F6-I7)=(AB5:AB247)),(((F6-I7)-K7)-1)),((F6-I7)-K7),(IF((F6-I7)=(AB5:AB247)),((F6-I7)-1),(F6-I7)))) Logic: Find if (F6-I7) is greater than O3 or smaller than K3 Do...

Hi all, Sorry for the lengthy description. I am a newbie here and thought I would include as much info as possible: I am attempting to put together a schedule (list of dates at this point), where each widget will need to be serviced on a set interval of days from a start date. Therefore I...

I am unable to give correct command in excel for a certain condition. My condition is - If a Company is Listed Company then OR even if Its a Public Company but fulfills certain criteria - the result should be "Applicable" else "Not Applicable" The Formula I am trying is -...

I have a recruitment database listing details of historical recruitment targets. The database has a column for the job position applied for, the date that their CV was received, the date of interview, the date we made an offer to the recruit, the date their CV was rejected (if it was), and the...

I have an AND function not working Cell F14 contains a working OR statement and returns "TRUE" when conditions are met Cell G14 contains a working IF statement and returns "TRUE" when conditions are met I want cell H14 to return "TRUE" when F14 and G14 both contain true. The following in...