entering a formula

M

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)

Would appreciate anyone's help!
 
S

Stan Brown

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)
Click to expand...

What if C3 contains neither? Or are you guaranteed that C3 will
contain one or the other?
Would appreciate anyone's help!
Click to expand...

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)
 
M

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).
 
S

Stan Brown

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).
Click to expand...

Happy to help! Thanks for letting me know it was helpful.
 
Top