Logo
    Logo

    Subject

    Computer Science

    Topic

    Computer Fundamental

    Suppose cells A5 and B5 contain the values 35000 and 100 respectively. In cell C5, if we apply the formula = IF (A5 <>20000, B5* 10%, B5* 20%), what will be the result in C5?

    ক)
    20
    খ)
    10
    গ)
    3000
    ঘ)
    None of the above

    Explanation

    In cell A5, you have the value 35000, and in cell B5, you have the value 100. You are using the IF formula in cell C5 with the following logic: `=IF(A5 <> 20000, B5 * 10%, B5 * 20%)` Here's how this formula works: 1. It checks whether the value in cell A5 is not equal to 20000. 2. If A5 is not equal to 20000, it will calculate `B5 * 10%` (which means 10% of the value in cell B5) and return that value. 3. If A5 is equal to 20000, it will calculate `B5 * 20%` (which means 20% of the value in cell B5) and return that value. In this case, A5 contains 35000, which is not equal to 20000. So, the formula will calculate `B5 * 10%`, which is 100 * 10% = 10. Therefore, the result in cell C5 will be 10.

    Related questions

    Properly arranged data is calledWhich type of network provides access to regional service providers and typically span distances greater than 100 miles?Which of the following IC was used in third generation of computers?কত bit এ ১ bite হয়?The output quality of a printer is measured byPhysical components of a computer are calledA set of flip flops integrated together is called ____How many parts are there in a computer system?

    Find Tutors

    View all Tutors