0
In excel 2007 if G7 has a date in it you want it to appear in Q7 but if G7 is blank you want Q7 to remain blank?
Wiki User
∙ 14y ago
In Q7 put the following formula: =IF(G7="","",G7)
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
In excel 2007 using IF function you have the logical test value if true and value if false but you want the cell with the formula to be blank if the cell you are referring to is left blank?
=IF(something,true,"")
How many columns in 2003 and 2007?
In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.
How Excel 2007 Converted to Excel 2003?
You can open a 2007 Excel spreadsheet with Excel 2003 if you save the file in Excel 2007 using "Save As" and select the 2003 compatibility mode.
Can you use Excel 2010 as Excel 2007?
The differences between them are not extensive so you can work in Excel 2010 easily if you are familiar with Excel 2007. You can save your files so that Excel 2007 will recognise them.
What appear when ALT is selected in excel 2007?
Keyboard shortcuts for menu options, like those used before the introduction of ribbons.
In excel 2007 using IF function I have the logical test value if true and value if false but I want the cell with the formula to be blank if the cell I am referring to is left blank.?
IF(Cell="","","Error Message") =IF(Cell="Yes","True",IF(D4="NO","False",IF(D4=" "," "," ")))
When was sumifs introduced to Excel 2008 or 2007?
The SUMIFS function was introduced in Excel 2007.
Is vlookup present in Excel 2007?
Yes, VLOOKUP is still in Excel 2007 and 2010.
When was Sum ifs introduced to Excel 2007?
The SUMIFS function first appeared in Excel 2007. The previous version, Excel 2003, did not have it.
How do you insert rows in Excel 2007 past IV?
Column IV is not the last column in Excel 2007, as it was in Excel 2003. In Excel 2003 the last column is IV which is column 256. In Excel 2007 the last column is XFD, which is column 16384.
Is Microsoft Excel 2007 used xlsx?
Excel 2007 does use the .xlsx extension for its workbooks.
What kind of operating system is Microsoft Excel 2007?
Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.Microsoft Excel 2007 is not an operating system. It is an application. The type of application it is is an electronic spreadsheet.
