nested if and and

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested If and And

Nested If and And

resolvedResolved · Low Priority · Version 2003

James has attended:
Excel Advanced course

Nested If and And

Please give an example of a formula that includes 'if' and 'and' and 'if' and 'or'

RE: Nested If and And/OR

Hi James,

Thank you for your question.

Enjoy the following example:

=IF(AND(B7>25000,C7>15000),"Yes","No")

This example returns the answer of Yes or No depending on whether both sets of criteria match. If one matches and not the other then No will be returned. If both match then Yes will be returned.

=IF(OR(B7>25000,C7>15000),"Yes","No")

This example returns the answer of Yes if any one of the criteria is matched and will only return No when both criteria do not match.

I hope this answers your question.

Regards

Simon


 

Excel tip:

Keyboard Shortcuts to Add Rows or Columns

Couple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns.

View all Excel hints and tips


Server loaded in 0.08 secs.