Recent content by stoke

Champion effort, thank you. Think i spent too long staring at that one! Cheers!

I am creating a financial kpi - actual vs budget. I need to dispaly the % difference pos / neg between the two and use that outcome to conditional format by colour. this formula gives kpi column: =(IF(OR(C45<0,D45<0),((D45/C45)-1),(IF(C45>0&D45>0,((ABS(D45/C45)-1)),ABS((D45/C45)+2)))))...

Splendid, many many thanks. as well as getting me out of a hole you've taught a valuable tool. Cheers,

Thanks Tony, although this only gives me the data for the week referenced in B1...... i need it to sum all data from week one through to week in referenced in B1. i can't see why this is happening with the product formula you gave me.......

hi, i have a budget and want to show year to date figure accoring to an input cell. i can extract data for that week with: =LOOKUP($B$1,'[xyz.xls]sheet'!J1:BI1,'[xyz.xls]sheet'!J29:BI29) B1 being input for desired week number J1:BI1 being the week numbers 1 to 52 and J29:BI29 being the data...

sorry - it is lotus 97 and outlok 2000.......

could any of you tell me how to import the diary from lotus cc into outlook calendar please? many thanks

Thank you very much guys -i really appreciate your help.

=IF(AND(D11=0,G11=0),&quot;0%&quot;,(G11-D11)/D11) i have the above formula - how do i ensure that if D11=0 and G10 = &gt;0 i get a result of 100%? whilst maintaining the above formula? i think that i need to add in an additional if statement but not sure how? Thank you,

Thanks Zathras - but i have used my own formula above to solve this situation - ddin't think of it using it for a while! still have no idea why the original situation came about though! appreciate your help,

Thanks for your quick response. I'm not comparing E17 to anything, i just need tobe able to use the value in that cell. The thing that is really perplexing me is how it works for all the cells and refernces but onot for this particular one! with regard to your comment about getting the...

at least to me anyway..... i have a table of calculating hours, the results are all correct and formatted the same (hh:mm) -09:40 00:05 01:20 -16:25 i use this formula: =CONCATENATE(A17,&quot; Variance&quot;,&quot; is &quot;,E17) where A is a descriptor for that which the hours apply to...

That works well, Thank you. i was just hoping to to automate the process a stage further.

Thanks, this doesn't have the desired result i want to be able to sum all the instances of data in colume J that match against a given group name. i have got as far as this: =IF(ISNA(VLOOKUP($E2,range,COLUMNS(range),FALSE)),&quot;-&quot;,VLOOKUP($E2,E2:L2,COLUMNS(range),FALSE)) which returns...

I have a large set of data which is grouped, each line has a group label column A (apple, orange, banana etc), each group could have zero or many line entries. some lines have data in column J and some don't. i want to look up and count the number of entires in colum J for each group (apple...