Question

Which of the following is an example of a complex formula?

A. =A1<= A14

B. Income – Expenses

C. SUM(A1:A14)

D. =150*.05


Plz hurry i need to know!

Answer 1

=A1<=A14

Step-by-step explanation:

complex formula in excel is which contain more than 1 mathematical operators . An order of mathematical operations are important to understand

there are different type of operators

• Arithmetic operators
• Comparison operators
• Text operators
• Operators reference

here Comparison operator is an example of complex formula . Comparison operator returns TRUE/FALSE it is use to compare two values

= Equal to

< Less than

> Greater than

>= Greater than or Equal to

<= Less than or Equal to