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!

If then statement to calculate data
 

Ric wrote:
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)))))

Your formula works for me. Can you describe what incorrect result you
are getting?

If then statement to calculate data
 

On Sep 2, 6:23*pm, smartin wrote:
Ric wrote:
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)))))

Your formula works for me. Can you describe what incorrect result you
are getting?

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

If then statement to calculate data
 

Ric wrote:
On Sep 2, 6:23 pm, smartin wrote:
Ric wrote:
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)))))
Your formula works for me. Can you describe what incorrect result you
are getting?

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

I can't think of a reason. Even a cell formatted as text should return
the correct result. If you are still stuck feel free to send the file to
me (the return address is good).