Question

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.

Answer 1

The formula is:

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

Step-by-step 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