Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
If conditions in Excel
Name: mgshilpa Date: May 6, 2009 at 04:31:56 Pacific OS: Windows XP CPU/Ram: 1Gb Product: Ibm / IBM THINKPAD Subcategory: General
Comment:
Hi,
I am not able to write a formula, please help me out.
Want to give if condition to 1 field which will reflect on other field. Like in D3 I have value 400 and in E3 I enter 0, when E3=0 then D3=0 and if E3=" " then D3=400 i.e., retain the same value.
Summary: As it is a csv file, it is only plain text and will loose any formatting you do on it when you close it (as you have already figured out.) If you only use it in excel, save it as an excel sheet rathe...
Summary: Try these two lines: Rows("1:1").Copy Windows("Book2").Range("A1").PasteSpecial Paste:=xlValues, Transpose:=True The operation to convert between horizontal and vertical is "Transpose:=True" If you do...
Summary: I'm building a test matrix in Excel and for some reason the macro that I am writing is having a problem reading the cells in the range that I pass to the functions. The test matrix is a workbook compr...
Shell script under window...
