If then statement to calculate data
Trying to look thru Column starting at line 74,63,52,41 and finally
going to 30 to see where data appears first. Even if there is data in
30 and 41, I want to look where the data appears first from bottom of
sheet ..say line 63. Have following fomula but not working:
=IF('Piazzo Ware'!C74<0,C74,IF('Piazzo Ware'!C63<0,C63,IF('Piazzo
Ware'!C52<0,C52,IF('Piazzo Ware'!C41<0,C41,IF('Piazzo Ware'!
C30<0,C30,0)))))
Please help!
|