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.
Answer:
a
Explanation:
a) the fcanf and textscan read lines one by one in the file and interpret with the format specified. If specified format is not present in the line then, then fscanf and textscan only read the portion that matches and halt processing.
b) fid is an identifier.
c) input functions (textscan, fscanf etc) are pre-defined input functions. They are used instead of while loop while reading a file.