Hi,
I have my data as below;
forum.jpg
I'm trying to achieve the following.
If there is a '0' to the left of a Cell in Column U which match's the Value of Cell 'W8' (sorry but its the bottom one 1.83) then return "-100" In the Cell Under FALSE (Cell 'W2').
If there is a '1' to the left of a Cell in Column U which match's the Value of Cell 'W8' then;
Times the value In Cell 'W8' (sorry but its the bottom one 1.83) by 100 and then Subtract 100
and display the Value (which would be "83") In the Cell Under FALSE (Cell 'W2')
How do i achieve this using VBA?
Many thanks for looking
Bookmarks