Calculations based on criteria in another cell

[marcidee]

Please can someone help with a script -

if column 'O' = .29 then in column 'I' = H/60
if column 'O' does not = .29 then column 'I' = 'H'

Then 'J' = 'I' * 'k'

The spreadsheet is very long so it should work for all lines in the spreadsheet

Thank you

 

[kweaver]

If I understand you correctly, you want I1 to be the formula: =IF(O1=0.29,H1/60,H1) and fill that down by either dragging the fill handle or double-clicking the fill handle.
Then J1: =I1*K1 and fill that down also.

Is that what you mean?

Alternatively, you could just put a formula in J and fill down. =K1*if(O1=0.29,H1/60,H1)

 

[marcidee]

Perfect - thank you very much