| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering a formula
i'm trying to create a spreadsheet with the following:
If C:3=NEW, THEN I:3=H:3+15 (I:3 AND H3 are in date format) If C:3=RENEWAL, THEN I:3=D:3-35 (again, I:3 and D:3 are in date format) Would appreciate anyone's help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering a formula
In I3: =IF(C3="NEW",H3+15,IF(C3="RENEWAL",D3-35,""))
"Moof" wrote: i'm trying to create a spreadsheet with the following: If C:3=NEW, THEN I:3=H:3+15 (I:3 AND H3 are in date format) If C:3=RENEWAL, THEN I:3=D:3-35 (again, I:3 and D:3 are in date format) Would appreciate anyone's help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering a formula
Thank you so much!
"Teethless mama" wrote: In I3: =IF(C3="NEW",H3+15,IF(C3="RENEWAL",D3-35,"")) "Moof" wrote: i'm trying to create a spreadsheet with the following: If C:3=NEW, THEN I:3=H:3+15 (I:3 AND H3 are in date format) If C:3=RENEWAL, THEN I:3=D:3-35 (again, I:3 and D:3 are in date format) Would appreciate anyone's help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering a formula
Thu, 19 Apr 2007 15:38:01 -0700 from Moof
: i'm trying to create a spreadsheet with the following: If C:3=NEW, THEN I:3=H:3+15 (I:3 AND H3 are in date format) If C:3=RENEWAL, THEN I:3=D:3-35 (again, I:3 and D:3 are in date format) What if C3 contains neither? Or are you guaranteed that C3 will contain one or the other? Would appreciate anyone's help! Lose the colons, for one thing. :-) In I3 you want this formula: =if(C3="NEW", H3+15, if(C3="RENEWAL", D3-35, "oops -- bad case")) If C3 always contains NEW or RENEWAL, you can simplify I3 to =if(C3="NEW", H3+15, D3-35) -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering a formula
wow. that was easier. (and, yes - I don't know why I put the colons in my
question, since I never put them in my formulas). "Stan Brown" wrote: Thu, 19 Apr 2007 15:38:01 -0700 from Moof : i'm trying to create a spreadsheet with the following: If C:3=NEW, THEN I:3=H:3+15 (I:3 AND H3 are in date format) If C:3=RENEWAL, THEN I:3=D:3-35 (again, I:3 and D:3 are in date format) What if C3 contains neither? Or are you guaranteed that C3 will contain one or the other? Would appreciate anyone's help! Lose the colons, for one thing. :-) In I3 you want this formula: =if(C3="NEW", H3+15, if(C3="RENEWAL", D3-35, "oops -- bad case")) If C3 always contains NEW or RENEWAL, you can simplify I3 to =if(C3="NEW", H3+15, D3-35) -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering a formula
Wed, 25 Apr 2007 15:52:00 -0700 from Moof
: wow. that was easier. (and, yes - I don't know why I put the colons in my question, since I never put them in my formulas). Happy to help! Thanks for letting me know it was helpful. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering IF formula | Excel Worksheet Functions | |||
| difference between + or = in entering a formula | Excel Worksheet Functions | |||
| Entering numbers in a cel formula | Excel Worksheet Functions | |||
| Problems entering a formula | Excel Worksheet Functions | |||
| entering matrix formula | Excel Worksheet Functions | |||
Hybrid Mode
