I tried but cannot get a formula to give me the result.
I am looking for a formula for ColH (Calc) that will do the following:
If Name1 OR Name2 is Fred And Type is A, For Side=Sell (PriceB-Price), For
software 發表在 痞客邦 留言(0) 人氣(0)
This is the formula that I am using which works very well. =IF(E2=0,quot;
quot;,(VLOOKUP(E2,Worcester,2,FALSE))). I have a range named WORCESTER for
looking up the answer that I need.
This is fine if the text in cell E2 DOES =Worcester. BUT, cell E2 will
sometimes =Portsmouth so I just edit my formula, which is not ideal. How can
software 發表在 痞客邦 留言(0) 人氣(0)
NETWORKDAYS is an extreemly usefull function especially in building timesheets.
This function is based on the United States of America system, but not all
the world has the same bank holidays, and in some countries one can also have
a working week with 6 days. I would suggest that somehow this function can
be customised by the user if possible.
software 發表在 痞客邦 留言(0) 人氣(1)
Copied a worksheet, now both original and copy have quot;^quot; in the cells, causing
formatting to be off. Words won't center horizontally or vertically and can't
retype cell contents w/out it putting the quot;^quot; back in the cell. HELP!Try Tools / Options / Transition / Untick 'Transition navigation keys' if it
is ticked.
software 發表在 痞客邦 留言(0) 人氣(4)
Hi everyone.
I'm looking to create a formula which to me is quite complicated.
In essence I need to carry out the following: -
software 發表在 痞客邦 留言(0) 人氣(0)
I have made an Excel (2003 version) spread sheet (370 entries) of money
spent. I want to check the column containing the dollar amounts to see if I
have duplicated any amounts.
How can I do this?
software 發表在 痞客邦 留言(0) 人氣(0)
I need to check all of the worksheets to collect and sum contents. Is there a
with method or something along those lines?
WITH worksheets
if a = b then
software 發表在 痞客邦 留言(0) 人氣(0)
Hi all
When creating a custom number format, how would you ask it to show text in
'bold and size 12 font'?
software 發表在 痞客邦 留言(0) 人氣(0)
Hi I have an excel workbook with 2 sheets, the first sheet has all the
information in it and the second is where I want the results displayed.
In sheet 1 have a row of dates (52 weeks of the year) in cells B1:BA1,
In column A starting at A2:A173 I have a list of names and in cells
B2:BA173 I have a list of duty numbers. In sheet 2 I have a formatted
software 發表在 痞客邦 留言(0) 人氣(0)
Is Excel 2007 released ? If not when is microsoft planning to release Excel
2007 ?
hi!
software 發表在 痞客邦 留言(0) 人氣(1)