Results 1 to 3 of 3

Thread: #Value! In excel

  1. #1
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    30
    Articles
    0
    Excel Version
    2013

    #Value! In excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello, please could someone help, I have a cell with =AG10/(1-AH10) in it but I get #Value! when not actually got any data in. AG10 has =IF(S10=1,Q10*R10,"") in it. The AH10 cell is used for a % and it all returns a figure with the % added to it. How could get rid of the #value!?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,854
    Articles
    0
    Excel Version
    O365
    Try

    =IFERROR(AG10/(1-AH10),"")

  3. #3
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    30
    Articles
    0
    Excel Version
    2013
    Excellent, thanks very much for your help!!

Posting Permissions

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