If then statement to calculate data

  • Thread starter Thread starter Ric
  • Start date Start date
R

Ric

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!
 
Your formula works for me. Can you describe what incorrect result you
are getting?
Click to expand...

It isn't giving me a number in C30 just a blank result (in this case
$180.00) I want it to look at each cell descibed aboe and stop at the
first value in this cases it's c30. it could be 74 next time
depending on column but it's not giving me the first value that is
displayed
 
Back
Top