IF A1 IS LESS THAN 408, then you need to check for A2 <40%. If the second is also true output 1, if not 0
IF A1 IS MORE THAN 408, then you need to check for A2 <50%. If the second is also true output 1, if not 0
How to calculate it in a single Excel cell?
bakusite bakusite
456 3 silver marks 22 bronze marks
- 40% regarding what? - Max
- @ Max is possible without interest. Check condition A2 <40 or as in the second case A2 <50 - bakusite
|
2 answers
I think this function will suit you:
=ЕСЛИ(И(A1<408; A2 < 40); 1; ЕСЛИ(И(A1>408; A2 < 50); 1; 0)) 
Max max
1.869 3 gold marks 11 silver marks 26 bronze marks
- Perfect solution! - bakusite
|
=--ЕСЛИ(A1<408;A2<0,4;A2<0,5) Here binary negation converts a logical value to a number.
vikttur vikttur
5.475 3 gold marks 12 silver marks 22 bronze marks
|