LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 258
Default CSE formula disregard blank cells

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill blank cells with an if formula? Gaby Excel Worksheet Functions 1 September 17th 07 04:26 PM
Formula Help: Add cells with certain text + cells that are blank Nicole L. Excel Worksheet Functions 3 February 27th 07 06:59 AM
Need blank formula cells rather than 0's Carl Excel Worksheet Functions 3 September 29th 06 03:43 PM
Need Help With Formula (Disregard my display name can't change) Need help with sumif Excel Discussion (Misc queries) 1 May 17th 06 02:42 AM
How do i keep cells blank until the formula is used? Ellen Excel Discussion (Misc queries) 4 February 3rd 06 12:44 PM


All times are GMT +1. The time now is 12:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"