Recent content by tarynmahon

Took me a little while to work out as should read like this =IF(MOD(E1,0.5)=0,"OK","Not OK") But it works, thank you

How do I determine the result in this instance please? Currently it either returns TRUE or FALSE but I'd like to specify different text, ie. "Ok" or "Not Ok"

This works perfectly Luke, thank you so much :)

I know you said it would be tricky to put the total on the right but do you think maybe including IF(cell="","Total" and incorporating a IF(Cell to the left<>"Total","" or will that not work? Not sure how I'd re-write the formula yet.

You are absolutely amazing!!!! :)

Hi, I'm trying to get a formula that looks up the amount of months remaining on a grant and then automatically adds in as many date columns as necessary. For instance, I have uploaded a file which has 8 months remaining, so the month columns that I will need populating are Apr 16 - Nov 16. The...

Hi, I'm very comfortable with pivot tables but I need a formula that will do this, I managed to fiddle with INDEX MATCH but I need to know how many instances there are in order to drag the formula down and it doesn't give me a unique list. I cant upload a sample because I'm trying to create a...

I have a list of different grants, each grant has a person responsible for it. On a separate sheet I would like to just lookup the persons name, ie. have a sheet per person and for a formula to list out each different grant associated with them. Is there a way of doing this? Oh, and I would need...

Wow, you really are a Ninja! Is it too much to express my undivided love for you?! Thank you so much! Taryn

Hi, Im getting so confused joining IF's together, does anyone have a more simplified way of writing my formula please? If I can get the formula in column Q right I can sort everything else, basically there are so many variables that need to be included please see below; Column BH-BM gives how...

Sorry, not perfect! For some reason if I change the start date it recalculates correctly but changing the end date does not prompt the recalculation ?

Perfect, thank you!

I have read the thread http://chandoo.org/wp/2010/06/01/date-overlap-formulas/ Which is handy but how can I get the result to tell me by how many days it overlaps by please?

Is there really no other way, my nested IF has now got completely out of hand! I tried helper columns but I dont think they will actually help its too complex

Ok, no worries, thank you for your help Taryn