Need explanation and some excel logic function examples

Asked By watson james 10 points N/A Posted on - 03/22/2013

 

Hi there,

I have been tinkering with Excel 2007 over the past couple days. I need Excel to perform some complex logical function with various data belonging to various customers of a retail store.

Can any one of you techies guide me and probably tutor me about the logical functions in Excel and perhaps provide some Excel logic function examples?

Thank you.

 

• Status: Open
• Question Views: 686
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Alice R Jones 0 points N/A #193766

Need explanation and some excel logic function examples

 

Hello,

Below table shows Excels function and their use:

And – Return true if all the conditions are true.

IF – Specify logical Condition to execute.

Not – Reverse the Logic of the argument

OR – Returns true if any of the conditions is true.

Excel 2007 new

IFERROR Returns a predetermined value if the formula result in an error or returns the formula result.

IF syntax =IF (Argument, value if the argument value is true, if the argument is false) Example =IF (A1=7, 0, 10) that is if the cell A1 has the value as 7 then the result is 0 otherwise it is 10.

HTH!

 

About Alice R Jones

Questions
8

Answers
99

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 03/23/2013
• Question Category: MS Excel