Results 1 to 3 of 3

Thread: #Value! In excel

  1. #1

    #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
    Try

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

  3. #3
    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
  •