Functions

Setting special format for a cell
Dear All, Could you please tell me how can I can set special format to a column? To be precise, I'd like to set such a format to the column of cells that it always shows like " ... sq.m.". For example, if i enter number 5 to the cell, it must then look like "5 sq.m". Regards, Ruslan ... 15 Mar 2010 12:21

Why does it display #### in my cell?
In cell I25 I have the following formula: =SUM(I11:I14) All it displays is #####, but when I hover over it, it gives me the correct answer on a popup tip-like window which is $3,400. So, if it knows the answer, why is it displaying with the pound signs instead? I think I've tried everything. ... 14 Mar 2010 19:54

Control On Cell Input
Hi, how do I put a control on a cell so that only a "-" i.e. -8 can be entered or conversely a control so that only a positive number can be entered. Thanks so much. ... 14 Mar 2010 05:28

How to use the Stop If True Condition for highlight cells
The Stop If True Condition don't seem to be work when you input an formula to highlight all cells greater than 100 and Stop If True, once it finds the first value that that is greater than 100. It highlights all the cells. ... 14 Mar 2010 10:55

Info between worksheets
All i want to do is fill a cell with a number and that number to go into a cell on another sheet as well. ... 13 Mar 2010 17:36

"Send to mail recipient" is dimmed out on my tool bar
I often use the "Send to mail recipient" option in my Excel 2007 to send a single sheet in an email, rather than attach the file. But this option is now dimmed and won't run. I've deleted it from the toolbar and reinstalled it, rebooted, etc., etc. All the other options in the tool bar continue to function as t... 13 Mar 2010 15:23

vlookup, concatenated named range
My function: =VLOOKUP(G7,"Asset"&F7,1,FALSE) "Asset"&F7 is a concatenation for a named range. If i type in manually, it works. Concatenated, it does not. Why does this not work? Not sure how or if to use indirect or offset. ... 13 Mar 2010 23:06

Highlight cells
I am trying to highlight a cell if it is empty. However, the cell in question is pulling data from another page in the worksheet, so the cell is not empty because it contains the address of the referenced cell. I have tried conditional formating and "IF" and couldn't get any of them to work. Any suggestions?... 13 Mar 2010 14:14

Multiple IF function
Hi, I'm trying to create a Life Insurance Calculator within Excel. I've already done a VLOOKUP to get the Relevant Premium Rate, but now I need to be able to reference back to them given the option. The four options available are: 1. Male Non-Smoker 2. Male Smoker 3. Female Non-Smoker 4. Female Smoker For... 13 Mar 2010 11:58

On Time Calculation
I have two columns, one is Sched Dely Date/Time (O5) and the other is Actual Dely Date/Time (N5). If my Sched Dely Date / Time is 04-Mar-10 05:00 PM and the Actual Dely Date / Time is 04-Mar-10 12:52 PM, the delivery would be on time. But if I use the IF function of O5>N5 it give me a TRUE answer when in fac... 12 Mar 2010 18:27