I have found a work around..
My problem is that my formulas were in fact delivering numbers as text. My formula was:
=IF(B6=GA$4,R6,)
What I found is that by changing the formula to:
=IF(B6=GA$4,R6,)*1
viola,... I have numbers
Anyone see any drawbacks with this approach?
Thanks to everyone esp Aladin for your help!!
I have a more interesting dilemma.
Step one would be find find the last instance in a row of 5 that is a negative number
Step two would be to find the first instance in a row of 5 that is a positive number
Yearly NPV Cash Flow | ($75,000) | $44,643 | $39,860 | $35,589 | $31,776 | $28,371 |
Overall NPV Cash Flow | ($75,000) | ($30,357) | $9,503 | $45,092 | $76,867 | $105,239 |
This is in regard to setting up a sheet where I need to know the BE and Payback.
Yearly NPV Cash Flow
($75,000)
$44,643
$39,860
$35,589
$31,776
$28,371
Overall NPV Cash Flow
($75,000)
($30,357)
$9,503
$45,092
$76,867
$105,239
<tbody>
</tbody>
Normally, I would look for the last instance of a neg figure in a row, in this example, (30,357) deduct 39,860 from 9,503 and so on. To clean the sheet up, I was looking for a function(s) to do this automatically.
thank you
I have a very similar question. I have a chart looking at some data and I want to find the lowest point in the chart. I am using: =MIN(IF(A1:BI1,A1:BI1)).
The problem is that in that data range I have values that are = to NA(). This is so the chart does not input those blank values as 0. However my Min function returns NA. Is there a way I can get the MIN function to ignore the cells that are valued as NA?
Thanks!