Thread: [Solved] Need help in making formula
View Single Post
 
Old 09-27-2011, 01:26 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

The first thing to note is that the IF formula doesn't need to pay attention to the row number - the result the formula returns only depends on the column.

So, in English the formula does this:
If the column header is 3 Or 4 Or 7 Or 8, Then Return 1. Otherwise return 0.

This is your homework, so I'm not going to just give you the formula. Have a look through your class notes and have a stab at it. There are several ways to do it, but I expect your teacher expects you to do it using the OR() function nested inside an IF() function.

Have a go and post back with what you've tried if you have no success.
Reply With Quote