Answered

Get the answers you need at Westonci.ca, where our expert community is always ready to help with accurate information. Get quick and reliable answers to your questions from a dedicated community of professionals on our platform. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

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

Thank you for your visit. We are dedicated to helping you find the information you need, whenever you need it. Thank you for your visit. We're committed to providing you with the best information available. Return anytime for more. Thank you for visiting Westonci.ca. Stay informed by coming back for more detailed answers.