I am trying to implement a CASE statement in VB with 2 variables.
I have attached a spreadsheet of how i want this to work.
There are basically 2 columns with UoM1 and UoM2.
The code needs to run down each row and check what's in UoM1 and UoM2.
Column E shows the calculations to do when it meets those conditions.
((I know conversions are not correct - this is just an example!))
How do i express this in VB code to run in excel?