Statement to be written in cell B10 :
IF ( B9 >= 470000, 35000, 1000)
Formula:
IF ( logical_test , [value_if_true] , [value_if_false] )
Explanation:
- logical_test = Net Profit After Tax (cell B9)
- value_if_true = 35000
<em>(if the Net Profit After Tax (cell B9) is greater than or equal to 47000 )</em>
<em> </em>3<em>.</em> value_if_false = 1000
<em>(if the Net Profit After Tax (cell B9) is lesser than 47000 )</em>
Each value should be separated by comma.
<u>Paired programming:</u>
Paired programming is a new technique where one person gets one another to<em> write the code</em>. Here one will write the code and other will start verifying as the type.
So we might think it is waste to employ two person for same task but it is not so. There are many <em>benefits in incorporating this technique</em>. Let us see those benefits one by one.
- <em>Inter-personal skill gets improved
</em>
- <em>Lower amount of coding mistake
</em>
- <em>Learn from each other
</em>
- <em>Peer review enhance collaboration
</em>
Challenges expect to arise during pair-programming
-
Two heads are superior to one. On the off chance that the driver experiences a <em>hitch with the code</em>, there will be two of them who'll take care of the issue.
- Builds up your <em>staff's relational aptitudes</em>. Working together on a solitary venture encourages your group to welcome the estimation of <em>correspondence and collaboration. </em>
Overcome Method
The most ideal approach to move <em>toward blending</em> is to accomplice two software engineers and have them share a PC. The pair ought to have the option to choose how to part the work, and it is prudent that they should <em>switch jobs frequently.</em>
Answer:
// here is code in Java.
// package
import java.util.*;
// class definition
class Main
{
// method that return sum of two sale value
public static int Add(int euroSales,int asiaSales)
{
// return the sum
return euroSales+asiaSales;
}
//main method of the class
public static void main (String[] args) throws java.lang.Exception
{
try{
// variables
int euroSales=100;
int asiaSales=150;
int eurasiaSales;
// call the function
eurasiaSales=Add(euroSales,asiaSales);
// print the sum
System.out.println("total sale is:"+eurasiaSales);
}catch(Exception ex){
return;}
}
}
Explanation:
Declare and initialize two variables "euroSales=100" and "asiaSales=150". Declare another variable eurasiaSales. Call the method Add() with euroSales and asiaSales as parameter. This method will add both the value and return the sum.This sum will be assigned to variable eurasiaSales.Then print the sum.
Output:
total sale is:250
