1,761 reputation
717
bio website
location Hong Kong, Hong Kong
age
visits member for 3 years, 11 months
seen 9 hours ago

Jul
4
comment If statement conditions
How about =max(0,formula_here)?
May
28
comment How to sum a range of cells with N/A values?
@JoeCarroll, you can use =AVERAGE(IF(ISNA(A1:A4),"",A1:A4))
Apr
22
awarded  Caucus
Mar
28
comment Convert fahrenheit in celsius in MS Windows Vista
I noticed. That's why I put it as comment instead of answer for your reference :)
Mar
27
comment Convert fahrenheit in celsius in MS Windows Vista
wolframalpha.com/input/?i=98.6F+to+C or google.com/?q=98.6F+to+C
Jan
14
revised How to create a random string of random length from the alphabet?
added 16 characters in body
Oct
30
comment Conditionally format a cell if it contains formula
Sorry, I haven't tested your answer until now. This trick is simple and beautiful. Accepted! Thanks. (By the way, the link is broken.)
Oct
30
comment Conditionally format a cell if it contains formula
Your answer is incomplete. I don't think you have tested.
Oct
30
accepted Conditionally format a cell if it contains formula
Sep
16
awarded  Notable Question
Aug
19
revised Excel - can't get the formula to copy correctly
added reference
Aug
19
answered Excel - can't get the formula to copy correctly
Aug
15
awarded  Nice Answer
Aug
11
awarded  Good Answer
Jul
20
awarded  Yearling
Feb
4
comment Rounding in Excel
cpast's edit changed the meaning of the question.
Jan
7
answered Microsoft excel formula on rounding up values
Dec
19
awarded  Popular Question
Dec
17
answered Excel: Check if column A has any values from Column B, and delete that value from Column A
Nov
16
comment How to change the delimiter when you copy from Excel and paste to notepad
Refer to my answer in another question: superuser.com/questions/206060/…