If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If/Then I'm afraid
Okay, another question. I need to make a cell subtract $50 from it's calculated total after a certain date. Don't know much about VBA yet and don't know how to put it in a cell at all (if it can be done). Thanks again in advance!
-Hill |
#2
|
|||
|
|||
If/Then I'm afraid
Hi Chris
please provide some more details. where is the date stored, etc. You may post some example data (plain text - no attachment please) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Okay, another question. I need to make a cell subtract $50 from it's calculated total after a certain date. Don't know much about VBA yet and don't know how to put it in a cell at all (if it can be done). Thanks again in advance! -Hill |
#3
|
|||
|
|||
If/Then I'm afraid
Frank,
I want the cell to basically say "IF the date is 06/15/2004, THEN (=M17*175+M19*425+M32*15+M38*25+M44*125); IF date is or = to 06/15/2004, THEN ([=M17*175+M19*425+M32*15+M38*25+M44*125]-50)" where the cell numbers (eg M17) are how many people will be attending and the regular numbers are dollar amounts. After 06/15/2004 there is a $50 cancelation fee invoked. Thanks, -Hill ----- Frank Kabel wrote: ----- Hi Chris please provide some more details. where is the date stored, etc. You may post some example data (plain text - no attachment please) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Okay, another question. I need to make a cell subtract $50 from it's calculated total after a certain date. Don't know much about VBA yet and don't know how to put it in a cell at all (if it can be done). Thanks again in advance! -Hill |
#4
|
|||
|
|||
If/Then I'm afraid
Hi
and there's the date stored? in a cell or do you want to use the current date? -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Frank, I want the cell to basically say "IF the date is 06/15/2004, THEN (=M17*175+M19*425+M32*15+M38*25+M44*125); IF date is or = to 06/15/2004, THEN ([=M17*175+M19*425+M32*15+M38*25+M44*125]-50)" where the cell numbers (eg M17) are how many people will be attending and the regular numbers are dollar amounts. After 06/15/2004 there is a $50 cancelation fee invoked. Thanks, -Hill ----- Frank Kabel wrote: ----- Hi Chris please provide some more details. where is the date stored, etc. You may post some example data (plain text - no attachment please) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Okay, another question. I need to make a cell subtract $50 from it's calculated total after a certain date. Don't know much about VBA yet and don't know how to put it in a cell at all (if it can be done). Thanks again in advance! -Hill |
#5
|
|||
|
|||
If/Then I'm afraid
Sorry, the date is also stored in a seperate cell. -Hill ----- Chris wrote: ----- Frank, I want the cell to basically say "IF the date is 06/15/2004, THEN (=M17*175+M19*425+M32*15+M38*25+M44*125); IF date is or = to 06/15/2004, THEN ([=M17*175+M19*425+M32*15+M38*25+M44*125]-50)" where the cell numbers (eg M17) are how many people will be attending and the regular numbers are dollar amounts. After 06/15/2004 there is a $50 cancelation fee invoked. Thanks, -Hill ----- Frank Kabel wrote: ----- Hi Chris please provide some more details. where is the date stored, etc. You may post some example data (plain text - no attachment please) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Okay, another question. I need to make a cell subtract $50 from it's calculated total after a certain date. Don't know much about VBA yet and don't know how to put it in a cell at all (if it can be done). Thanks again in advance! -Hill |
#6
|
|||
|
|||
If/Then I'm afraid
I could just use the current date though. -Hill ----- Frank Kabel wrote: ----- Hi and there's the date stored? in a cell or do you want to use the current date? -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Frank, I want the cell to basically say "IF the date is 06/15/2004, THEN (=M17*175+M19*425+M32*15+M38*25+M44*125); IF date is or = to 06/15/2004, THEN ([=M17*175+M19*425+M32*15+M38*25+M44*125]-50)" where the cell numbers (eg M17) are how many people will be attending and the regular numbers are dollar amounts. After 06/15/2004 there is a $50 cancelation fee invoked. Thanks, -Hill ----- Frank Kabel wrote: ----- Hi Chris please provide some more details. where is the date stored, etc. You may post some example data (plain text - no attachment please) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Okay, another question. I need to make a cell subtract $50 from it's calculated total after a certain date. Don't know much about VBA yet and don't know how to put it in a cell at all (if it can be done). Thanks again in advance! -Hill |
#7
|
|||
|
|||
If/Then I'm afraid
Hi
if the date is for example stored in cell X try =IF(X1DATE(20904,6,15),M17*175+M19*425+M32*15+M38 *25+M44*125,M17*175+M 19*425+M32*15+M38*25+M44*125-50) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Sorry, the date is also stored in a seperate cell. -Hill ----- Chris wrote: ----- Frank, I want the cell to basically say "IF the date is 06/15/2004, THEN (=M17*175+M19*425+M32*15+M38*25+M44*125); IF date is or = to 06/15/2004, THEN ([=M17*175+M19*425+M32*15+M38*25+M44*125]-50)" where the cell numbers (eg M17) are how many people will be attending and the regular numbers are dollar amounts. After 06/15/2004 there is a $50 cancelation fee invoked. Thanks, -Hill ----- Frank Kabel wrote: ----- Hi Chris please provide some more details. where is the date stored, etc. You may post some example data (plain text - no attachment please) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Okay, another question. I need to make a cell subtract $50 from it's calculated total after a certain date. Don't know much about VBA yet and don't know how to put it in a cell at all (if it can be done). Thanks again in advance! -Hill |
#8
|
|||
|
|||
If/Then I'm afraid
It worked! Thx, -Hill ----- Frank Kabel wrote: ----- Hi if the date is for example stored in cell X try =IF(X1DATE(20904,6,15),M17*175+M19*425+M32*15+M38 *25+M44*125,M17*175+M 19*425+M32*15+M38*25+M44*125-50) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Sorry, the date is also stored in a seperate cell. -Hill ----- Chris wrote: ----- Frank, I want the cell to basically say "IF the date is 06/15/2004, THEN (=M17*175+M19*425+M32*15+M38*25+M44*125); IF date is or = to 06/15/2004, THEN ([=M17*175+M19*425+M32*15+M38*25+M44*125]-50)" where the cell numbers (eg M17) are how many people will be attending and the regular numbers are dollar amounts. After 06/15/2004 there is a $50 cancelation fee invoked. Thanks, -Hill ----- Frank Kabel wrote: ----- Hi Chris please provide some more details. where is the date stored, etc. You may post some example data (plain text - no attachment please) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Okay, another question. I need to make a cell subtract $50 from it's calculated total after a certain date. Don't know much about VBA yet and don't know how to put it in a cell at all (if it can be done). Thanks again in advance! -Hill |
#9
|
|||
|
|||
If/Then I'm afraid
Chris
building on Frank's suggestion, another option is: =M17*175+M19*425+M32*15+M38*25+M44*125-IF(X1DATE(2004,6,15),0,50) Regards Trevor "Frank Kabel" wrote in message ... Hi if the date is for example stored in cell X try =IF(X1DATE(20904,6,15),M17*175+M19*425+M32*15+M38 *25+M44*125,M17*175+M 19*425+M32*15+M38*25+M44*125-50) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Sorry, the date is also stored in a seperate cell. -Hill ----- Chris wrote: ----- Frank, I want the cell to basically say "IF the date is 06/15/2004, THEN (=M17*175+M19*425+M32*15+M38*25+M44*125); IF date is or = to 06/15/2004, THEN ([=M17*175+M19*425+M32*15+M38*25+M44*125]-50)" where the cell numbers (eg M17) are how many people will be attending and the regular numbers are dollar amounts. After 06/15/2004 there is a $50 cancelation fee invoked. Thanks, -Hill ----- Frank Kabel wrote: ----- Hi Chris please provide some more details. where is the date stored, etc. You may post some example data (plain text - no attachment please) -- Regards Frank Kabel Frankfurt, Germany Chris wrote: Okay, another question. I need to make a cell subtract $50 from it's calculated total after a certain date. Don't know much about VBA yet and don't know how to put it in a cell at all (if it can be done). Thanks again in advance! -Hill |
Thread Tools | |
Display Modes | |
|
|