SOLVED

Seeking for a Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2019229%22%20slang%3D%22en-US%22%3ESeeking%20for%20a%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019229%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20help%20in%20finding%20a%20formula.%20Here%20are%20my%20conditions%3A%3C%2FP%3E%3CP%3E1.%20I%20need%20to%20get%203%20Results%200%2C%200.5%20and%201.%3C%2FP%3E%3CP%3E2.%20My%20condition%20is%20if%20the%20value%20of%20the%20cell%20is%20not%20given%20then%20the%20output%20should%20be%200%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20If%26nbsp%3B%20my%20cell%20value%20is%200%3CX%3E%26lt%3B%3D4%20then%20my%20result%20should%20be%200.5%2C%3C%2FX%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20If%20my%20cell%20value%20is%20X%26gt%3B4%20then%20result%20should%20be%201.%3C%2FP%3E%3CP%3E3.%20Is%20it%20possible%20to%20give%20the%203%20conditions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20glad%20with%20the%20answers.%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2019229%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2019279%22%20slang%3D%22en-US%22%3ERe%3A%20Seeking%20for%20a%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019279%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F913185%22%20target%3D%22_blank%22%3E%40sai9497%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20you%20the%20value%20is%20in%20cell%20A2.%3C%2FP%3E%0A%3CP%3EIn%20another%20cell%2C%20for%20example%20B2%2C%20enter%20the%20formula%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(A2%26gt%3B4%2C1%2CIF(A2%26gt%3B0%2C0.5%2C0))%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D((A2%26gt%3B0)%2B(A2%26gt%3B4))%2F2%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello guys,

 

I need a help in finding a formula. Here are my conditions:

1. I need to get 3 Results 0, 0.5 and 1.

2. My condition is if the value of the cell is not given then the output should be 0,

    If  my cell value is 0<X<=4 then my result should be 0.5,

    If my cell value is X>4 then result should be 1.

3. Is it possible to give the 3 conditions.

 

I would be glad with the answers. Thanks in advance.

2 Replies
best response confirmed by sai9497 (New Contributor)
Solution

@sai9497 

Let's say the value is in cell A2.

In another cell, for example B2, enter the formula

 

=IF(A2>4,1,IF(A2>0,0.5,0))

 

or

 

=((A2>0)+(A2>4))/2

@Hans Vogelaar Thank you for you response. It worked absolutely.