IF function

**danny.p** · 08-29-2011, 08:39 PM

Hi Guys,

I am creating a fee register spreadsheet for a construction job.

The first column will read: ie/
HYDRAULIC ENGINEER
Abc company
123 company
456 company

ELECTRICAL ENGINEER
ghj company
lkp company
typ company

The third column will have the fee amount.

In the second column I want an IF function where if 'yes' is selected from a drop down list it will sum only these fee amounts(I have already created the drop down list).

Thankyou in advance,
Danny

**danny.p** · 08-29-2011, 09:08 PM

Find attached excel spreadsheet

**danny.p** · 08-29-2011, 10:05 PM

Figured it out using a SUMIF function.

However I am still trying to solve the date situation in the dummy attachment

**inayat** · 08-30-2011, 04:22 AM

Originally Posted by danny.p

Figured it out using a SUMIF function.

However I am still trying to solve the date situation in the dummy attachment

=ROUNDUP(DATEDIF(C22,C23,"d")/7,0)

However even if you go 1 day above a particular week it will give the data as next week.. example.. if there are 36 days it will take it as 6 weeks. If you want it other way round then play with the ROUNDUP, ROUND, ROUNDDOWN function. Hope this helps.

**inayat** · 08-30-2011, 04:41 AM

Danny.. Please ignore the previous msg as i did not check the entire question. Please find attached the file with the solution. I dont know whether this is the best solution but it is something that will work... Anyways I have just put in formula for 5 weeks, you need to go ahead of that... Please let me know if this works out for you.

Cheers