software

how do you go about assignig the lesser of two values to a cell in an IF
structure? Something like...

Hello,

I have to extract a value from the same cells in over 30 workbooks. Is there
a quick way to name all the workbooks in an array and state the array in the

How many IF OR statements can one have in one formula?

I need to calculate the number of calander days from one date to another.
For example: if the start date is January 1, 2006 and the end date is January

pl give me proper solution.

I moved column M next to column E so that I could see them better side by
side, but I lost colums F-L in the process. I know the data is still there

I need merge rows. How to merge rows?

I have spreadsheet someone set up when you type lower case it displays
uppercase. How can I turn that off?

Hi everybody!