software

Formula in cell =(B5-A5) I want to check if result is negative and if so
replace result with 0

how do i round to the nearest 0.5

I can't right-click inside of a specific cell anymore so that I can format.
I can highlight an entire column and right-click and it gives me all the

I need to find out the amount of time between two dates for filling out
funeral benefits. The form asks how long the person has been alive in Years

Is there any quick way to display a list of numbers in thousands? for
instance, how to change the display of 10,000 into 10 other than put in a

Im trying to drag and copy a list from a sheet.

I would like to be able to count the number of different iteams in one column
whose dates are less than 30 days older than the current date in another

I want to get a 1 returned when I quere a cell if the fill color is Rose
(colorindex=38). Do you use the IF function or is there another way to do

I have a date inserted in cell a1 (28/2/2007). In cell A2 I want the

I have used INDIRECT function which has reference to other workbook.