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]
