Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good morning --
I'm setting up a workbook for several users, in which they will gradually add data over the months and years ahead. I want to set it up to compare the current month's ratios to the maxima and minima over the four years' worth they'll eventually have. In the meantime, I need to figure out how to get the CSE formula to disregard the cells that aren't filled in yet. Here's an example: A B 1 (blank) (blank) 2 1 5 3 2 4 4 3 3 5 4 2 6 5 1 I'd like a formula a la {=min(b1:b6/a1:a6)} Is there something I can put in the $1:$1 row to get the CSE formula to disregard it until filled? Or is there some kind of =IF() statement I can use inside the CSE formula? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill blank cells with an if formula? | Excel Worksheet Functions | |||
Formula Help: Add cells with certain text + cells that are blank | Excel Worksheet Functions | |||
Need blank formula cells rather than 0's | Excel Worksheet Functions | |||
Need Help With Formula (Disregard my display name can't change) | Excel Discussion (Misc queries) | |||
How do i keep cells blank until the formula is used? | Excel Discussion (Misc queries) |