Hi Andy,
Have you tried
*Vinifera =*
If(Quantity Grafted = "own roots" and Grow method =
"Pots",Order/(80/100),Order*2)
This way your 'if 'statement needs both items to evaluate to 'true', and
should give the result you want.
Mike
Andy Gordon wrote:
I am trying to use a conditional statement as follows,
*Vinifera =*
If(Quantity Grafted="own roots" and if(Grow
method="Pots"),Order/(80/100),Order*2)
something is not working
Andy
--
Andy Gordon
Manager
KC Vines & Root Stocks
PO Box 1054
MILDURA VIC 3502
Voice: 03 5024 8812
Fax: 03 5024 8834
Mobile: 0407 309961
