 Need explanation and some excel logic function examples

Asked By 10 points N/A Posted on -

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. SHARE
Answered By 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! 