IF Function

Relevant answer

Celia Muller 4 days ago

Be a bit more Specific, what word and where is that word (criteria) from aother CELL Value or a Fixed word in Function "Word" ? . =IF(L3<>"Word","",H86) or =IF(L3="Word",H86,"") .

  • "Word" can be Replaced by a CELL.REF.
1 Like

Relevant answer

Lacey Jenkins 5 days ago

Lucy Kemmer you can obviously accomplish this in many ways, here are few alternatives which i would like to share with you

• Formula used in cell A2


This is without any table of reference and is hard coded.

• Formula used in cell B2

= IF(HOUR(F2)>=22,"Night",IF(HOUR(F2)>=16,"Evening",IF(HOUR(F2)>=5,"Morning","Night")))

• Formula used in cell C2


This uses the same table reference like the below two more

• Formula used in cell D2


• Formula used in cell E2



Relevant answer

Rachelle Pfeffer II 1 week ago

it should start with =if( F2, "", DATEDIF(F2,B2,"d")) , so it does nothing if F is empty, but does whats asked if F2 is whatever.


Relevant answer

Devante Kshlerin 1 week ago

It's not yet solved.

I'm getting the date stamp successfully but...

''The issue is that it resets every time Column ''M'' updates because of the external query that i'm running. Any way around that?''


Relevant answer

Lacey Jenkins 1 week ago

Jose Daugherty you can use either of the formulas to accomplish your desired output. Excel dependent note that.

• Formula used in cell J3


Fill Down and applicable to Excel 2010+ onwards.

• Formula used in cell K3


Fill Down & Formula applicable to Excel 2007+ onwards.

• Formula used in cell L3


Fill Down & Formula applicable to Excel 2019+ onwards.

Note for Excel 2019 you need to have valid MS Office 2019 License.

1 Like

Relevant answer

Alvena Schinner 1 week ago

try: =IF(OR(AND(O34<15000,O36="Yes"),AND(O35="Yes",O36="Yes")),0,O34)

The formula uses the OR function to check two different conditions:

  1. If O34 < 15,000 and O36 = "Yes".

  2. If both O35 and O36 = "Yes".

If either of these conditions are true, the formula returns 0. If neither of these conditions are true, the formula returns the value of O34. Hope it helps


Relevant answer

Rudy Lubowitz 1 week ago

You can only do this with VBA if you want it to automatically enter each time you add a row. Personally, I'd just input the date one time into a large amount of rows, then delete off the ones you don't use at the end of the day.


Relevant answer

Destin Boyle 2 weeks ago

Try this, I think this is what you want?



Relevant answer

Westley Kerluke 2 weeks ago

Better formula =if(c104="","",(i104-h104)-($L$4*(c104="H9"))) Why do the calculation 3 different times... It's already the same unless H9

1 Like