Formula: If with 3 conditions Solved

Question

Hello,

I'm looking to create a formula with 3 conditions:

I have a first column with 0, 2, or 7
I would like the following result: if I have the number 0 or 7 I want index 1, if it's 2 index 0

Thank you in advance,

Configuration: Windows / Internet Explorer 10.0

PHILOU10120 · Answer

Hello Cabrina  Try this  =IF(OR(A1=0,A1=7),1,0)  -- It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from their mistakes.

userbear · Answer

Hello,
there is also the possibility of creating this formula which will allow for a potential modification.
=If(A1=0,7,If(A1=1,0,2))
Thus, this formula will give you 3 variables.

But Cabrina's response, in your case, is perfectly valid.
--

The essential thing is not to live but to live well.

JvDo · Answer

Hello everyone,  A less readable formula but that gets the job done: =1+A1*(A1-7)/10  Best regards

Untel · Answer

=--(A12)

Formula: If with 3 conditions

4 réponses

Canon mb5350 - cartridge replacement impossible

Texture issues in enshrouded

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.