I
Ice Man
I am trying to create a PO form with some variable conditions and need
guidance.
Field $G$16=default Multiplier for many or all line items.
Starting at row 19, Col B=Qty. F=Multiplier Over-ride. G=Unit Cost. H=Unit
Price.
When getting a quote, some times the vendor provides a multiplier factor
($G$16) and the Unit Cost (G19 through G-whatever). Field $G$16 will be
either empty (Delete), blank (space bar) or have a decimal value (eg .2275).
Column F is an over-ride field of the Multiplier. It will be empty
(Delete), blank (space bar), a character that causes the Multiplier to be
ignored or a different Multiplier value (eg: .2125).
Column H is our Unit Price by considering the Unit Cost (Col G) and any
Multiplier and over-ride.
If Qty (Col B) does not contain a number value, field H in this row has no
value. It may display $ - , or display nothing even if there is a Unit
Price (Col G), a Multiplier ($G$16) or an over-ride (Col F). A text msg
alerting the user there is no Qty entered would be great but not a 'must
have'.
If a Qty (Col B) exists;
If there is no Multiplier and no Multiplier over-ride, field H will be the
value from G
If there is a Multiplier and no over-ride value, Field H is the product of G
* $G$16
If there is a Multiplier but field F="x" or "X", field H will be the value
from G
If there is or is no Multiplier and field F has a value, field H is the
product of G * F
The default multiplier $G$16 is superceded by the over-ride.
I have this working about 85% but won't contaminate your thinking with mine
so I won't include the formula I have to this point unless it is asked for.
Thank you for being here.
guidance.
Field $G$16=default Multiplier for many or all line items.
Starting at row 19, Col B=Qty. F=Multiplier Over-ride. G=Unit Cost. H=Unit
Price.
When getting a quote, some times the vendor provides a multiplier factor
($G$16) and the Unit Cost (G19 through G-whatever). Field $G$16 will be
either empty (Delete), blank (space bar) or have a decimal value (eg .2275).
Column F is an over-ride field of the Multiplier. It will be empty
(Delete), blank (space bar), a character that causes the Multiplier to be
ignored or a different Multiplier value (eg: .2125).
Column H is our Unit Price by considering the Unit Cost (Col G) and any
Multiplier and over-ride.
If Qty (Col B) does not contain a number value, field H in this row has no
value. It may display $ - , or display nothing even if there is a Unit
Price (Col G), a Multiplier ($G$16) or an over-ride (Col F). A text msg
alerting the user there is no Qty entered would be great but not a 'must
have'.
If a Qty (Col B) exists;
If there is no Multiplier and no Multiplier over-ride, field H will be the
value from G
If there is a Multiplier and no over-ride value, Field H is the product of G
* $G$16
If there is a Multiplier but field F="x" or "X", field H will be the value
from G
If there is or is no Multiplier and field F has a value, field H is the
product of G * F
The default multiplier $G$16 is superceded by the over-ride.
I have this working about 85% but won't contaminate your thinking with mine
so I won't include the formula I have to this point unless it is asked for.
Thank you for being here.