Hi,
I am trying to parse a string beginning at the word "else" and ending at a number.
if(LowIncomeSubsidyLevel = 1) then 27.00 else (if(LowIncomeSubsidyLevel=0.75) then 33.40 else (if( LowIncomeSubsidyLevel=0.50) then 39.80 else (if(LowIncomeSubsidyLevel=0.25) then 46.30 else 52.70)))
The results should be parsed as:
else (if(LowIncomeSubsidyLevel=0.75) then 33.40
else (if( LowIncomeSubsidyLevel=0.50) then 39.80
else (if(LowIncomeSubsidyLevel=0.25) then 27.00
else 52.70)))
I have been using the MID formula with somewhat success.
I am trying to parse a string beginning at the word "else" and ending at a number.
if(LowIncomeSubsidyLevel = 1) then 27.00 else (if(LowIncomeSubsidyLevel=0.75) then 33.40 else (if( LowIncomeSubsidyLevel=0.50) then 39.80 else (if(LowIncomeSubsidyLevel=0.25) then 46.30 else 52.70)))
The results should be parsed as:
else (if(LowIncomeSubsidyLevel=0.75) then 33.40
else (if( LowIncomeSubsidyLevel=0.50) then 39.80
else (if(LowIncomeSubsidyLevel=0.25) then 27.00
else 52.70)))
I have been using the MID formula with somewhat success.