Search results for query: *

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)))))...

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...

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

=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,

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...

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...

does anybody know of how i can produce graphs other than the ones in the standatrd excel templates? maybe there is a download for some additional templates? Thanks,

i have time formatted as custom [h]:mm a1: 38:45 (actual time) a2: 33:10 (planned time) a3: =a2-a1 the result is ####### this result only occurs if the answer is negative...... i have tried various formatting/number/column width etc options with no success. any help appreciated Thanks!

i have a set of data running from columnn A to AA, and several thousand rows long. column E gives a descriptor name for all the rows below it, until a new descriptor is given, but does not give the descriptor for all the rows until the a new descriptor is given. My first 'set' of data runs...

I have an excel chart plotting two sets of data - promary x axis is hours and secondary is a percentage. The graph goes + and -, ie above and below zero. The problem is that the zero mark for both axis is not aligned and thus makes the chart difficult to interpret. as an example, when i put in...

this is on;y a small matter, but one that i find irritating, as i keep hitting F1 when i want to hit F2. if i could disable this function i would be chuffed.

hi there, i have a unique identifier in a1,sheet2 and need to extract the related data from sheet 2 - ie find in column a then extract related data in column b to b2,sheet2 then related data in c2 and so on....... i have this: =IF(ISNA(VLOOKUP(F2,datarange,2,FALSE)),'YTD RM...

hi there, i have a unique identifier in a1,sheet2 and need to extract the related data from sheet 2 - ie find in column a then extract related data in column b to b2,sheet2. i have this: =IF(ISNA(VLOOKUP(F2,datarange,2,FALSE)),'YTD RM 2002-2003'!F2,VLOOKUP(F2,datarange,2,'YTD RM...

sure you guys must be tired of these: i have data in a range - b2:10 with corresponding data alongsisde c2:c10 in f2 i have data that i want to lookup in b2:10 and return the corresponding data from c2:c10 into g2 i have: =VLOOKUP(F2,B2:B10,2,FALSE) and get #N/A clearly i'm doing something...

interesting one i have following data from a mainframe system representing dates as (d)dmmyy. 70303 40303 120303 200303 60203 190303 260303 This file has 10000 entries, i need to be able to sort the data in date order. Formatting the data as date doesn't work as it thinks the values are...

how do i change the default reminder time for calender / task items in outlook? currently it defaults to 5.00pm..... Thanks in advance,

hi all, sheet 1, a1 is linked to sheet 2, a1, whose cell refs have been made absolute. if i return the cell refs to relative, and then copy (or paste special formulas) sheet 1, a1 to sheet 1, a2 then i get the correct formula , ie it reads =, but the wrong result. in this case the reference...

hi, i have the following data (showing delivery times) in 24 hr format 00:15 23:50 00:01 23:25 i want the average of these delivery times, within this window of, in this instance, 50 mins rather than over a whole 24 hr period - but excel calculates the average delivery time as 11:52 hrs! at...

hi, i have the folowing formula: =IF(E6>C6,&quot;3&quot;,IF(E6=C6,&quot;1&quot;,IF(E6<C6,&quot;0&quot;))) that returns a value even if there is no data in the cell. I only want the formula to return a value when the cell has data in it. can anybody help me please? Thank you.