Hello,
I'm having the following problem
I have a worksheet with the following columns
Column B contains a date entered by the user.
Column C contains a numerical code.
Column D needs to have a formula which does the following.
If the code in column C (on the same row) equals 20, then
a certain formula has to be executed.
If the code in column C is NOT 20 another formula has to
be executed.
No problems so far.
Column E needs to have a formula which does the following.
If the code in column C is 11, 12, 13, 14 or 20 then a
certain formula has to be executed.
If the code in column C is NOT 11, 12, 13, 14 or 20 then
another formula has to be executed.
Both of these formula's are "IF" formula's
(If "condition = ---- then do this if not then do that)
What formula('s) can I use to do this ?
In the future I would like to use VBA for this, but for
the time being this (unfortunately) has to be done
using formula's only.
For the VBA version I would like to use "Case"
For example :
Case = 20
Calculate the values in columns D and E.
Case = 30
Calculate the values in columns D and E.
(And so on, and on, and on....)
Or are there better ways to do this ?
And now my final (stupid ?) question ?
Is it possible to "integrate" a formula in VBA ?
Something like this ?
SomeVariable = SUM(A10 + 20)
I would be very gratefull, if anyone could answer these questions.
Thanks,
Frits Jager
(The Netherlands)
I'm having the following problem
I have a worksheet with the following columns
Column B contains a date entered by the user.
Column C contains a numerical code.
Column D needs to have a formula which does the following.
If the code in column C (on the same row) equals 20, then
a certain formula has to be executed.
If the code in column C is NOT 20 another formula has to
be executed.
No problems so far.
Column E needs to have a formula which does the following.
If the code in column C is 11, 12, 13, 14 or 20 then a
certain formula has to be executed.
If the code in column C is NOT 11, 12, 13, 14 or 20 then
another formula has to be executed.
Both of these formula's are "IF" formula's
(If "condition = ---- then do this if not then do that)
What formula('s) can I use to do this ?
In the future I would like to use VBA for this, but for
the time being this (unfortunately) has to be done
using formula's only.
For the VBA version I would like to use "Case"
For example :
Case = 20
Calculate the values in columns D and E.
Case = 30
Calculate the values in columns D and E.
(And so on, and on, and on....)
Or are there better ways to do this ?
And now my final (stupid ?) question ?
Is it possible to "integrate" a formula in VBA ?
Something like this ?
SomeVariable = SUM(A10 + 20)
I would be very gratefull, if anyone could answer these questions.
Thanks,
Frits Jager
(The Netherlands)