Working out the m2 if greater than

[Benjando]

hi

I was wondering if any one can help me with a problem

What i need is that when i mark as a 1 in Q9 it make reference to call vale on sheet 2 . all the actual formula is in R9 what I'm after is when the m2 of height( B9 ) x Width (C9 ) is less than 1m2 it make reference to a cell in sheet 2 and if it is over 1m2 i will reference to a different cell

i realize that i will have to change the formula in R9 will have to change

[Richard Buttrey]

Hi,

You don't say what the units are so I'll assume B9 & C9 are in mm.

Please Login or Register  to view this content.

Change A1 & A2 as appropriate.

Regards