Search results

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

This is probably a stupid question but is there a simpler way of doing loads of IF formulas? Each IF has different criteria and a different result, I was thinking I could do a SUMPRODUCT but that would only return one result that matches all the different criteria wouldnt it? The formulas are in...

Oh ok, thank you, I'll give it a go, thanks very much

Thank you but I'm looking for a way of doing it without using SUMPRODUCT

Sorry I don't think you understand, I don't need the formula to change, the foruma is just in one cell so no copying down, the only thing I want to change is one of the criteria but instead of it referencing one cell I need it to reference a column

Hi All, I was wondering if there was a better way of doing this formula; *Hint* (Its exactly the same formula 4 times) =SUMIFS(APR14.DATA!$O:$O,APR14.DATA!$Z:$Z,$C11,APR14.DATA!$X:$X,'P&L CATS'!$A$1)+SUMIFS(APR14.DATA!$O:$O,APR14.DATA!$Z:$Z,$C11,APR14.DATA!$X:$X,'P&L...

Thank you

No sorry I cannot as my permissions at work dont allow, I've simplified the formula so that its generic you should be able to work it out but please ask if you need me to explain anything else

I have the following formula; =SUMPRODUCT(--([Lookupsheet]A:A=A1),--([Lookupsheet]B:B=B1),--([Lookupsheet]C:C=C1),[Lookupsheet]D:D) As there are more than one row that matches this criteria my formula is adding all the instances in "D" together, they're all the same so I just want to return the...

I have just started up on my own in Bookkeeping/Spreadsheet Modelling and have my first client who just wants me to reformat his 4 year cash flow forecast, he's got all the figures he just doesn't like the format that the person that created it did it in, Obviously it depends on his requirements...

Perfect Colin, thank you