Need help with IF function
I would like to create an IF function formula for a date field. Currently I have 'estimated deployment date' field that is always filled in, another field, the 'rollout end date' calculates off the '...
Forum Discussion
Adam,
You helped me before...hoping you can do so again. I tried to use the same formula again in a different field. Right now I have a field populate off of an Expected Infile Volume calculation. I want this field to update so if the Actual Supplement Volume is not supplied it will fill in with Expected Volume calculation....
Below is what I put as the formula. I have something wrong because now the field remains zero and only changes if the Actual Supplement Volume is filled in.
If (IsNull ([Actual Supplement Volume]),(([Expected Infile Volume]*0.1)*1.75/21),([Actual Supplement Volume]/21))
Thanks in advance :)
------------------------------
Beth
------------------------------
You helped me before...hoping you can do so again. I tried to use the same formula again in a different field. Right now I have a field populate off of an Expected Infile Volume calculation. I want this field to update so if the Actual Supplement Volume is not supplied it will fill in with Expected Volume calculation....
Below is what I put as the formula. I have something wrong because now the field remains zero and only changes if the Actual Supplement Volume is filled in.
If (IsNull ([Actual Supplement Volume]),(([Expected Infile Volume]*0.1)*1.75/21),([Actual Supplement Volume]/21))
Thanks in advance :)
------------------------------
Beth
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendIt sounds like the IsNull ([Actual Supplement Volume]), is not working. Look for a setting
Treat blank values as "0" in calculations
and uncheck that. That will cause the formuals which refer to this field to differentiate between a zero and a (blank).
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Treat blank values as "0" in calculations
and uncheck that. That will cause the formuals which refer to this field to differentiate between a zero and a (blank).
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- Thank you, Mark. I couldn't find that setting so I just changed the formula to say if [Actual Supplement Volume]=0, and it is working!
------------------------------
Beth
------------------------------