EnigmaUnknown
New Member
- Joined
- Sep 28, 2011
- Messages
- 9
Hello Everyone!
I need help with a spreadsheet I building.
I am creating a spreadsheet to track immunization for our guys overseas.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
I am trying to put multiple arguments into an IF statement, but I cannot get it right. I keep getting a too many arguments error.
<o></o>
This is what I am trying to get it to do.
<o></o>
For multiple series Immunizations, like Hep A, I would like it so when they put in the date for Hep A Shot 1 (Cell E3), the next cell (F3)will calculate the date when the next one is do. I also want the cell next to that (Cell G3) to calculate how many days until the next shot is due.
<o></o>
I have these working with the formulas below. I also set them up so if there is no date in E3, then the F3 and G3 cells will be blank.
<o></o>
F3 – Hep A Shot 2 Due - =IF(E3="","",E3+180)<o></o>
G3 – # of Days - =IF(F3="","",F3-TODAY())<o></o>
<o></o>
<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="WIDTH: 594.75pt; HEIGHT: 150.75pt" id=Picture_x0020_2 alt="" type="#_x0000_t75" o:spid="_x0000_i1025"><v:imagedata o:href="cid:image001.png@01CC7D1C.5CA4C400" src="file:///C:\Users\seversol\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"></v:imagedata></v:shape><o></o>
<o></o>
<o></o>
I want to added an argument in G3 to return “SC”(Series Complete)When the following criteria is met.<o></o>
· There is a Date in E3 and H3
<o></o>
In other words, when they have entered dates for both Shot 1 and Shot 2, then it will show the “SC” and not continue to count down the days.
<o></o>
I did some research online and I came up with this, but I don’t know if I am using the right IS statement or how to incorporate it into my IF statement.
<o></o>
=IF(OR(ISNUMBER(e3,H3,),"SC",(F7="","",F7-TODAY()))<o></o>
<o></o>
Any ideas?
<o></o>
<o></o>
I need help with a spreadsheet I building.
I am creating a spreadsheet to track immunization for our guys overseas.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>I am trying to put multiple arguments into an IF statement, but I cannot get it right. I keep getting a too many arguments error.
<o
></o>This is what I am trying to get it to do.
<o
></o>For multiple series Immunizations, like Hep A, I would like it so when they put in the date for Hep A Shot 1 (Cell E3), the next cell (F3)will calculate the date when the next one is do. I also want the cell next to that (Cell G3) to calculate how many days until the next shot is due.
<o
></o>I have these working with the formulas below. I also set them up so if there is no date in E3, then the F3 and G3 cells will be blank.
<o
></o>F3 – Hep A Shot 2 Due - =IF(E3="","",E3+180)<o
></o>G3 – # of Days - =IF(F3="","",F3-TODAY())<o
></o><o
></o><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="WIDTH: 594.75pt; HEIGHT: 150.75pt" id=Picture_x0020_2 alt="" type="#_x0000_t75" o:spid="_x0000_i1025"><v:imagedata o:href="cid:image001.png@01CC7D1C.5CA4C400" src="file:///C:\Users\seversol\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"></v:imagedata></v:shape><o></o><o
></o><o
></o>I want to added an argument in G3 to return “SC”(Series Complete)When the following criteria is met.<o
></o>· There is a Date in E3 and H3
<o
></o>In other words, when they have entered dates for both Shot 1 and Shot 2, then it will show the “SC” and not continue to count down the days.
<o
></o>I did some research online and I came up with this, but I don’t know if I am using the right IS statement or how to incorporate it into my IF statement.
<o
></o>=IF(OR(ISNUMBER(e3,H3,),"SC",(F7="","",F7-TODAY()))<o
></o><o
></o>Any ideas?
<o
></o><o
></o>
