Got a urgent question.
Could someone please help me write a basic formula in column D of the attached.
Basically I need the value to appear in each row of col D, so that the value is equal to either col B's percentage of the corresponding value in Col A or the value in col C.
Example for row 3.
7.9m x 8% = 0.632m. This is lower than the 5m in Col C, so the value in Col D should be 0.62m
If Col C's figure was lower, then this figure would be taken. I cannot remember how to use the MIN command here. I think it is =MIN((B3*A3),C3)?