LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PE
 
Posts: n/a
Default Evaluting 2 cells, adding one to largest for another cell.

I am struggling with getting this to work correctly.

If cell C40 and there is no number in cell D5 then I want the number
automatically put in C5 to be C4+1, but if D5 also has a number in it then I
want the number in C5 to be D4+1.

Example:
Cell C4 Cell C5
555 0
Cell C5
556
But if:
Cell C4 Cell C5
555 556
Cell C5
557

I don't know why I am having such a problem with this it seems like it
should be a simple task, but can't get it to work correctly.
Thanks,
PE
 
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
How do I total range of cells that have checks in checkboxes? instructorjml Excel Discussion (Misc queries) 2 March 23rd 06 11:56 AM
Deferring conditional formatting? Pheasant Plucker® Excel Discussion (Misc queries) 14 March 17th 06 08:17 PM
Adding a row to worksheet does not update cell references in another. blausen Excel Worksheet Functions 5 February 25th 06 09:14 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 09:50 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"