if(or

Okay all the big brains, I have what is probably a simple formula that has been stumping me for two days now. I did not find a specifically related thread so I'm adding this one. Problem: I want a cell to give a value based on two separate cells. The first is a standard number cell. The second...

Normally when I write formulas, I have no need for ranges. But in this case, I need L10:L75. =IF(L10:L75="","blahblah","blahblahblah") Doing it individually doesn't return a #value! error, but doing the range does. As someone who has never needed a range before, I'm not sure if I'm doing...

I have three columns of numbers <tbody> A1 B1 C1 1158.50 1562.50 1250.00 </tbody> I need a formula that looks at all three numbers and returns one of them based on criteria. If A1 is bigger than B1 or C1, then B1 should be returned. If C1 is bigger than A1, then C1 should be...

I am having problems with trying to get this function to work. The Search function in the command seems to require a different format. Basically I am checking a long GL string, If $A2 contains 509 fill the cell with 509, If $A2 contains 511 fill the cell with 511, If $A2 contains 510 fill the...

I have created a array function using index match based on the age of my data. I have gotten the first criteria to work but can not seem to get the second to work. I have created dynamic ranges for my case numbers, Age and Employees Working...

Hi, I need help with a formula that meets the following conditions. Result as “Y” in a cell when meeting all of the following conditions. CA3<200 CB3<230 CD3<ce3*0.35< span=""></ce3*0.35<><CE3*0.35 CF3<cg3*0.1 or="" cf3<1="" (either="" one="" of="" these="" conditions)<=""...

Hi, I need help with a formula that meets the following conditions. Result as “Y” in a cell when meeting all of the following conditions. CA3<200 CB3<230 CD3<CE3*0.35 CF3<CG3*0.1 or CF3<1 <ce3*0.35 <ce3 <ce3*0.35 <cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<=""...

Hi Guys, having a little trouble with an if(or formula. It isn't returning anything, just the dreaded #VALUE!. Is it something wrong with the formula? Am I writing it incorrectly? =IF(OR(A2="CUSTOMER REQUESTED REVIEW",A2="ACCEPTED",A2="ASSIGNED TO PROVIDER",A2="PROVIDER ACCEPTS WITH...

Happy New Year Everyone: =IF(OR(EN3=1,3,EO3=1,2,EP3=1,1,0) I have three columns that are returning a 1 or 0 based upon a True or False condition. If the Conditions in Cell EN3 =1, I want to return the value 3 If the Conditions in Cell E03 =1, I want to return the value 2 If the Conditions in...