Return result when condition is met

  • Thread starter Thread starter Gotroots
  • Start date Start date
G

Gotroots

The following formula returns the row number

=IF(INDIRECT("A"&ROW(IV4))="","",ROW())

I want it now to only return a result if "D" contains the value "No record"

Thank you
 
Gotroots said:
The following formula returns the row number

=IF(INDIRECT("A"&ROW(IV4))="","",ROW())

I want it now to only return a result if "D" contains the value "No record"

Thank you
Click to expand...


Do you mean this:


=IF(INDIRECT("D"&ROW(IV4))="No record",ROW(),"")
 
you can nest your if statement like this

=IF(INDIRECT("A"&ROW(IV4))="","",IF(INDIRECT("A"&ROW(IV4))="D",ROW(),""))
 
Hello guys,

Sorry, but neither solutions worked.
Perhaps it's to do with the fact that the values in "D" are the result of a
relative formula
 
If you mean both the conditions then try

=IF(AND(INDIRECT("A"&ROW(IV4))="",INDIRECT("D"&ROW(IV4))="No
record"),"",ROW())
 
Actually, Glenn's solution was successful after all, typo error on my part.

Thank you all for contributing.
 
Back
Top