MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need a formula that works


Posted by mark on December 22, 2001 9:46 AM

Dawson James 0 0 1 0 1 0 0 1 0 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 PART TIME
expeert from my excel spread sheet the problem is school meals for a child can be either part time full time or not at all (NO MEALS) I need the computer to calculate tis . If you look at the info above 0 = no meal, 1 = meal taken But if a child has a mela on a wednesday and a friday themn he is partime. provide he does not take meal the rest of the week but this must be do as an average because the other two factors are that he can go sick.(very unlikely to be every Monday,Tuesday and Thursday) also he might want to odd meal during the week. any odd children I can leave the formula out and just make a permanant cell. Here is my attempt but it does not work if he goes sick it treats as part time HELP>>>>>>
=IF(SUM(B31:M31)=0,"NO MEALS",
IF(AVERAGE(B31:M31)=1,"FULL TIME","PART TIME"))

also the the next problem is Full time = £100 and Part Time = £40 how can i get the computer to reconise output of above formula and convert the out put of £100 or £ 40 or £0 .



Posted by Aladin Akyurek on December 22, 2001 10:12 AM

Mark --

It's unlear to me what the lay-out of your data is. You can post first 10 rows of your data (including the labels you might have by doing the following:

Activate an empty cell, type =, select the first 10 rows of data, go to the formula bar and press F9. Copy the whole thing between braces and paste it in the follow up. Give also the expected results per row in addtion to the sample data.

Aladin

============