IF formula with multiple conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-3104645%22%20slang%3D%22en-US%22%3EIF%20formula%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3104645%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20definitely%20not%20good%20at%20this%20and%20would%20need%20some%20kind%20help%20from%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20formula%20that%20says%3A%3C%2FP%3E%3CP%3EIF%20column%20F%20has%20name%20(MARIO)%20and%20column%20N%20has%20the%20value%20(%3CSPAN%3E0%20-%2084.9%25)%20then%20column%20N%20will%20need%20to%20be%20(0.12).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20value%20in%20brackets%20will%20change.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAlso%2C%20if%20possible%2C%20I%20would%20like%20that%20the%20value%20displayed%20in%20column%20N%20is%20taken%20from%20a%20table%20that%20would%20be%20in%20another%20tab%20of%20the%20same%20sheet.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20a%20lot%20for%20helping!%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3104645%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3104822%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3104822%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1294657%22%20target%3D%22_blank%22%3E%40elmai735%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20(0%20-%2084.9%25)%20a%20literal%20text%20value%20or%20does%20it%20stand%20for%20the%20range%20from%200%25%20to%2084.9%25%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3104872%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3104872%22%20slang%3D%22en-US%22%3Eit's%20just%20a%20text%20value.%20I%20will%20have%20to%20use%20the%20following%3A%3CBR%20%2F%3E0%20-%2084.9%25%3CBR%20%2F%3E85%20-%2094.9%25%3CBR%20%2F%3E95%20-%2099.9%25%3CBR%20%2F%3E100%25%3CBR%20%2F%3ERepetition%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3104920%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3104920%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1294657%22%20target%3D%22_blank%22%3E%40elmai735%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECreate%20a%20lookup%20table%20like%20this%2C%20on%20a%20sheet%20named%20(for%20example)%20List%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1118.png%22%20style%3D%22width%3A%20164px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344585i482DF290D070F66E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1118.png%22%20alt%3D%22S1118.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EOn%20the%20other%20sheet%2C%20enter%20the%20following%20formula%20in%20row%202%20in%20the%20column%20where%20you%20want%20to%20return%20the%20result%3A%3C%2FP%3E%0A%3CP%3E%3DIF(F2%3D%22Mario%22%2C%20IFERROR(VLOOKUP(N2%2C%20List!%24A%241%3A%24B%245%2C%202%2C%20FALSE)%2C%20%22%22)%2C%20%22%22)%3C%2FP%3E%0A%3CP%3EThis%20can%20be%20filled%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hey guys, 

I'm definitely not good at this and would need some kind help from you.

 

Is there a formula that says:

IF column F has name (MARIO) and column N has the value (0 - 84.9%) then column N will need to be (0.12).

 

The value in brackets will change.

Also, if possible, I would like that the value displayed in column N is taken from a table that would be in another tab of the same sheet.

 

Thanks a lot for helping! 

7 Replies

@elmai735 

Is (0 - 84.9%) a literal text value or does it stand for the range from 0% to 84.9%?

it's just a text value. I will have to use the following:
0 - 84.9%
85 - 94.9%
95 - 99.9%
100%
Repetition

@elmai735 

Create a lookup table like this, on a sheet named (for example) List:

S1118.png

On the other sheet, enter the following formula in row 2 in the column where you want to return the result:

=IF(F2="Mario", IFERROR(VLOOKUP(N2, List!$A$1:$B$5, 2, FALSE), ""), "")

This can be filled down.

thanks @Hans Vogelaar ! it doesn't seem to work though, no error, just empty result
Could you please also show me the simple version without the Vlookup in case I want to add the table on the same sheet?
thanks so much for helping!

@elmai735 

It would work the same with the table on the same sheet. Here is my test workbook.

@Hans Vogelaar 

 

thanks! not sure what's wrong but the cell is empty 

FORMULA.PNG

@elmai735 

You originally mentioned that the breakdown was in column N, so the formula looks at column N.

The breakdown is now in column L, so you should change N2 to L2.