Answered

Westonci.ca is the best place to get answers to your questions, provided by a community of experienced and knowledgeable experts. Get quick and reliable solutions to your questions from a community of seasoned experts on our user-friendly platform. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly platform.

Provide an example of formula (with proper syntax) that would check whether cell B5 has a negative number, and return a value of "negative" if it was and "not negative" the value was zero or higher.

Sagot :

MrRoyal

Answer:

The formula is:

=IF(B3<0,"negative","not negative")

Explanation:

The formula can be split as follows:

= --> This begins all excel formulas

IF --> This means that we are writing an IF condition formula

B3<0, ---> This is the condition being tested

"negative", ---> This is the result is the condition is true

"not negative" ---> This is the result is the condition is false

We hope this was helpful. Please come back whenever you need more information or answers to your queries. Thank you for your visit. We're dedicated to helping you find the information you need, whenever you need it. Your questions are important to us at Westonci.ca. Visit again for expert answers and reliable information.