View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ric[_7_] Ric[_7_] is offline
external usenet poster
 
Posts: 15
Default 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!