| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Evaluting 2 cells, adding one to largest for another cell.
try in C5
=if(isnumber(d5),d5+1, if (C40,C4+1,"otherwise")) "PE" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Evaluting 2 cells, adding one to largest for another cell.
Hy PE,
I assuming that the right column on your samble is D. so, try =IF(D4=0,(C4+1),(D4+1)) Hope this helps Regards from Brazil Marcelo "PE" escreveu: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Evaluting 2 cells, adding one to largest for another cell.
Once I rearranged the cells in your format it did work.
Thank you, PE "bj" wrote: try in C5 =if(isnumber(d5),d5+1, if (C40,C4+1,"otherwise")) "PE" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Evaluting 2 cells, adding one to largest for another cell.
Hi Marcelo,
Yes you are correct the Cells on the right should have been D and you formula worked great a little simplier then the previous one. Thank you, PE "Marcelo" wrote: Hy PE, I assuming that the right column on your samble is D. so, try =IF(D4=0,(C4+1),(D4+1)) Hope this helps Regards from Brazil Marcelo "PE" escreveu: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Evaluting 2 cells, adding one to largest for another cell.
Hey Marcelo,
Is there a way that if cell C4 and C5 were both zero that it wouldn't change C5 until the user put a number in that cell? PE "Marcelo" wrote: Hy PE, I assuming that the right column on your samble is D. so, try =IF(D4=0,(C4+1),(D4+1)) Hope this helps Regards from Brazil Marcelo "PE" escreveu: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I total range of cells that have checks in checkboxes? | Excel Discussion (Misc queries) | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
