| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel base 10 log for Optical Density vs %T
Check your other postings ... and be patient.
"BillO" wrote: Hi I have two possible data columns in a spreadsheet, I can enter the OD or %T I would then like to calculate the average, max, and min of either column after the data set is filled in. The formulat to convert %T to OD =(10^-C19)*100 what I am having trouble with is setting up a single cell to calculate either the %T column or OD column depending on which has data in it and not counting blank cells as 0 or 100. %T OD 10.00 1.00 I hope some one can respond with an easy solution. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error in Excel 2007 while using MS Wireless Note. Optical Mouse 40 | Excel Discussion (Misc queries) | |||
| probability density function | Excel Worksheet Functions | |||
| Change base 6 to base 10? | Excel Discussion (Misc queries) | |||
| Density graphs in Excel? | Charts and Charting in Excel | |||
| Help on producing a Probability Density Function please! | Charts and Charting in Excel | |||
Threaded Mode
