Home

Using the if function

%3CLINGO-SUB%20id%3D%22lingo-sub-475363%22%20slang%3D%22en-US%22%3EUsing%20the%20if%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-475363%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20not%20good%20with%20the%20if%20function.%26nbsp%3B%20How%20do%20I%20use%20the%20if%20function%20when%20I%20want%20to%20show%20the%20following.%3C%2FP%3E%3CP%3E1-30%20days%2C%20I%20go%20that%20one%20working%3C%2FP%3E%3CP%3E31-60%20days%2C%20I%20cannot%20get%20this%20function%20to%20work.%26nbsp%3B%20How%20do%20I%20go%20write%20this%20on%20the%20if%20function%20where%20it%20should%20be%20greater%20than%2031%20days%2C%20but%20less%20than%2060%20days.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-475363%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-475578%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20the%20if%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-475578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324010%22%20target%3D%22_blank%22%3E%40Tommentions%3C%2FA%3E%26nbsp%3B%2C%20partly%20depends%20on%20what%20your%20calculations%20are.%20Some%20of%20variants%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DIF(A1%26gt%3B60%2C%22one%22%2CIF(A1%26gt%3B30%2C%22two%22%2C%22three%22))%0A%3DLOOKUP(A1%2C%7B0%2C31%2C60%7D%2C%7B%22one%22%2C%22two%22%2C%22three%22%7D)%0A%3DIF(AND(A1%26gt%3B30%2CA1%26lt%3B%3D60)%2C%22one%22%2C%22two%22)%0A%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Tommentions
Occasional Visitor

Hello, I am not good with the if function.  How do I use the if function when I want to show the following.

1-30 days, I go that one working

31-60 days, I cannot get this function to work.  How do I go write this on the if function where it should be greater than 31 days, but less than 60 days. 

1 Reply

@Tommentions , partly depends on what your calculations are. Some of variants could be

=IF(A1>60,"one",IF(A1>30,"two","three"))
=LOOKUP(A1,{0,31,60},{"one","two","three"})
=IF(AND(A1>30,A1<=60),"one","two")

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies