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!?
#Value! In excel
- Thread starter Wings
- Start date
- Joined
- Mar 21, 2011
- Messages
- 1,960
- Reaction score
- 0
- Points
- 36
- Excel Version(s)
- O365
Try
=IFERROR(AG10/(1-AH10),"")
=IFERROR(AG10/(1-AH10),"")