If statement

[Stclements1]

I want to write an if statement that shows the value of one cell in another cell if the value in another cell is met.
Columns H I J K each are related to different projects if there is a value >0 in any of these columns the reciprocal value in column N will then be displayed in either columns P Q R S, thus if there is a value in cell H2 > 0 then the value of cell M2 is displayed in cell P2, if there is a value in I2 >0 then the value in M2 is displayed in cell Q2 and so on, column M being the constant for all the rows.

 

[etaf]

you say the value in N and then use M - is that a typo and you say reciprocal - maths is 1/cell
In P2
=IF(H2>0, $M2,"")
and copy across to Q , R & S

 

[Stclements1]

you say the value in N and then use M - is that a typo and you say reciprocal - maths is 1/cell
In P2
=IF(H2>0, $M2,"")
and copy across to Q , R & S

Absolutely perfect, many thanks.

 

[etaf]

you are welcome