Suppose cells A5 and B5 contain the values 35,000 and 100 respectively . In cell C5, if you apply the formula = IF (A5 20000, B5 * 10%,B5 * 20%), what will be

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

Suppose cells \(A^{5}\) and \(B^{5}\) contain the values 35,000 and 100 respectively . In cell \(C^{5}\), if you apply the formula = IF (\(A^{5}\) <> 20000, \(B^{5}\) * 10%,\(B^{5}\) * 20%), what will be the result in \(C^{5}\) ? ?

Created: 1 year ago | Updated: 1 week ago | Created By:

Jannatul Ferdush

7,000

3,500

0 23

Institution: Bangladesh Bank Exam: Bangladesh Bank - Assistant Director - 2015 ||
Topic: ICT (তথ্য ও যোগাযোগ প্রযুক্তি) Subject: Computer and ICT (তথ্য ও যোগাযোগ প্রযুক্তি)

No comments yet.

Suppose cells \(A^{5}\) and \(B^{5}\) contain the values 35,000 and 100 respectively . In cell \(C^{5}\), if you apply the formula = IF (\(A^{5}\) <> 20000, \(B^{5}\) * 10%,\(B^{5}\) * 20%), what will be the result in \(C^{5}\) ? ?

To find the average value of A1, A2, A3, which of the following is not a correct formula ?

What will be the result of the formula = Max (Average (B1, B2), Product (B3 : B4)) where the value of B1 = 26, B2 =30, B3 =12 and B4 2

Sidebar

Advertishment

Need Custom Questions or Projects?

Social Links

Quick Links

Stay Connected