Scott Castaline wrote:
Brian Barker wrote:
At 11:18 24/09/2007 -0400, you wrote:
I have a calc form that I want to create a logical function for
based upon which of 2 columns would have a date entered. So IF
(D1=??/??/?? AND F1=(); then G1=75 or IF (D1=() AND F1=??/??/??;
then G1=15*I1). I cannot have a date entered into both D1 and F1, it
has to be either one. If there is a date in D1 then a fixed amount
gets put into G1. If F1 is the one that has a date then a formula is
used for the amount put into G1. I'm not sure of the best way to
approach this. Any suggestions?
You haven't defined the problem, in fact. In order to do this most
efficiently, we need to know what will be in the cells when there is
not a date there - something? nothing? If you know there will be
nothing, then
=IF(F1="";75;15*I1)
will work.
Otherwise it is quite difficult to test for a date, I think. The
internal storage is just an integer, of course, and the date display
comes about because of the cell formatting. You can test for the
formatting, but that could be there without the date, so that may not
help.
I trust this helps.
Brian Barker - privately
the determining factor of which field gets a date entered is which of
2 events occurred. If event occurred then cell D1 will contain the
actual date the event took place, entered by the user (yours truly in
this case). If event B happens then the actual date that event B
occurred would be entered in cell F1. By the way this form is used as
what i call a very awkward invoice. The condition has to determine
which column a date was entered which is guided by what event occurred
and based upon this one of 2 things has to happen in this cell. Either
$75.00 gets entered into G1 if the date was entered into D1 or the
value of H1 * $15.00 gets entered if the date is in F1. I'm not sure
if this can even be done, I'm just trying to eliminate the amount of
data that has to be entered. I could just add another column like I'm
doing with H, and just look to see what value or if true/false
condition in that cell to determine what happens in G.
IF (I1=1;75;H1*15)
That would probably be the simpler way to do it, but then it's another
step that has to be taken during data entry. I could probably insert
the column used inbetween the 2 columns with dates and then hide it
when I go to print. The other thing that I was thinking was that under
no circumstance would a date be entered into both D1 and F1 since it
event A and event B are an either or, but never and situation. In
recent years I have been known to do dumb things like entering a date
in both cells. So I'm trying to tie in a means of preventing this at
the same time. I have tried looking through the guides (documents),
but I can't find any reference to anything close, so I'm not sure if
it can be done.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
I have been trying different approaches to my problem. The printed area
of the sheet comprises of columns A - G;
Column A = Date
Column B & C = Text
Column D = Date (If it relates to we'll say event "A", otherwise it will
be blank)
Column E = Text
Column F = Date (If it relates to event "B", otherwise it will be blank)
Column G = $$$$
Column I = 0 or 1
Column J = 1 or 2 (If event B)
Currently I have the following function in I =IF(D2="";0;1)
Currently I have the following function in G =IF(I2=1;75;
IF(I2="";"";15*J2))
This works in that when I enter a date into D2 (Event A occurred), the
function will put a 1 in I2 and then the function in G2 will put $75.00
into G2. If event B happens I skip D2 and enter a date into F2. The
function in I2 then enters a 0 into I2, and once I enter a value into
J2, that value times 15 will get entered into G2. Initially all rows at
column G displays $0.00, is there a way to suppress this until after all
data has been entered for that record/row?
I'm not sure if this is clear, as to what I'm trying to do. Let me know
if you need more info. If necessary, contact me of list and I will
"publish" the solution to the list, for anyone's interest.
TIA
Scott
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
