Computer Science, asked by goforgoal, 3 months ago

create worksheet"salary sheet" in the workbook and change its name to salary December


plz answer this it's urgent​

Answers

Answered by sameershaikh53
0

Answer:

please mark me as brainliest

Explanation:

Functions Explained

OCTOBER 2, 2010 BY MYNDA TREACY 1,069 COMMENTS

if or and if and formulas

Excel IF AND OR functions on their own aren’t very exciting, but mix them up with the IF Statement and you’ve got yourself a formula that’s much more powerful.

In this tutorial we’re going to take a look at the basics of the AND and OR functions and then put them to work with an IF Statement. If you aren’t familiar with IF Statements, click here to read that tutorial first.

IF Formula Builder

IF Formula Builder

Our IF Formula Builder does the hard work of creating IF formulas.

You just need to enter a few pieces of information, and the workbook creates the formula for you.

AND Function

The AND function belongs to the logic family of formulas, along with IF, OR and a few others. It’s useful when you have multiple conditions that must be met.

In Excel language on its own the AND formula reads like this:

=AND(logical1,[logical2]....)

Now to translate into English:

=AND(is condition 1 true, AND condition 2 true (add more conditions if you want)

Similar questions