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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested IF OR statement

Nested IF OR statement

ResolvedVersion 2003

Wed 11 Feb 2009, 16:50 Delegate Angela said...

Angela has attended:
Excel VBA Intro Intermediate course

Nested IF OR statement

Hi

I've written a nested IF statement but would like to write it as as IF OR statement

=IF(Calcs!D8=TRUE,Calcs!E8,IF(Calcs!L13=TRUE,Calcs!M13,IF(Calcs!S14=TRUE,Calcs!T14,IF(Calcs!T26=TRUE,Calcs!U26))))

Please could you tell me how to do this?

Many thanks

Angela

Thu 12 Feb 2009, 09:02 Trainer Amanda said...

RE: Nested IF OR statement

Hi Angela

Thanks for your question.

Can you explain a bit more about what you require the formula to do, as I'm not sure if writing the formula as an IF OR statement will achieve the result you are after.

Does the formula you have written above work currently?

You're welcome to email the spreadsheet through to me with an explanation if that will be easier. My email address is amanda@stl-training.co.uk

Kind regards
Amanda

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet

Did you know you could give the tabs in your worksheet different colours?

This is particularly useful when organizing all your worksheets relating to a particular period or year, for example.

Right click a tab
Select Tab Colour
And choose your favourite colour!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Nested IF OR statement

Nested IF OR statement

RE: Nested IF OR statement

Excel articles

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet