=IF(Master!R6=6, ROW(),"")

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved

=IF(Master!R6=6, ROW(),"")

The above formula shows #VALUE! as the cell has no value
in it

Please can I expanded on this formula so the cell would
be blank if no data present.

Thankyou.
 
Can't duplicate your problem.

When you say "as the cell has no value in it", I assume you mean the cell
"Master!R6", while the actual formula is on another sheet.

Something from your description is missing.
 
I was not thinking Hence when you
gave me The correction for Shows #Value!

The other value you are refering to is
linked to =IF(ISERROR(VALUE(LEFT($F$6,1))),"",VALUE(LEFT
($F$6,1)))now I have the desired result

Thankyou very much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=IF(Master!R7=2, ROW(),"") 4
combine the two into a single formula please 3
formula finds values in apparently blank cells 1
Formula help please 1
Same row different Answer. 2
Matching Data in Excel 2002 4
Deleting/Clearing duplicate range of cells 4
Why doesn't excel count function update automatically? 1

Back
Top