Results 1 to 6 of 6

remove #n/a from my cell

Threaded View

  1. 01-09-2009, 05:24 AM #1
    ravihotwok
    ravihotwok is offline
    Forum Contributor
    Join Date
    10-13-2008
    Location
    wales (uk)
    Posts
    113

    remove #n/a from my cell

    i have the following formula:

    =REPT(Estimator!D8,(Estimator!E8="Yes"))

    when it is not in use or false it displays #N/A

    Can anyone tell me how I can just have it blank when not true?

    Thanks
    Last edited by ravihotwok; 01-13-2009 at 06:27 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1