[users] Calc: Formula or Logical Function

[Scott Castaline]

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?

TIA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]