2- Suppose you have the fallowing code segment convert it to suitable excel formula , Note: Suppose the Range A2:A6 content the Gender value (Male or Female), and the range B2:B6 content the any...

=20 then s=s+B[i] c=c+1 end if Output s/ e Your answer "/>
Extracted text: 2- Suppose you have the fallowing code segment convert it to suitable excel formula , Note: Suppose the Range A2:A6 content the Gender value (Male or Female), and the range B2:B6 content the any numerical value S=0 ;C=0 For i=2 to 6 If Ali] ="male" and B[i] >=20 then s=s+B[i] c=c+1 end if Output s/ e Your answer