FRED_SHEET
New Member
- Joined
- Oct 13, 2017
- Messages
- 48
#VALUE! Error
I have an Excel spreadsheet in which a random number and a blank is generated for a Numerator for a Fraction in Column F and a Denominator is generated in Column G using a formula based on the number which is generated in Column F.
When I attempt to generate the resulting value for the fraction in Column I. I am getting an error message of #VALUE!.
What is wrong with the formula I am using?
I want 0.00000 to appear in Column I if Column F is blank.
Numerator Random Number Generator – Column F
=IF(RAND()<0.3," ",RANDBETWEEN(1,63))
Denominator Function – Column G
=IF(F9>=32,64,IF(F9>=16,32,IF(F9>=8,16,IF(F9>=4,8,IF(F9>=2,4,IF(F9>=1,2,0))))))
Decimal Equivalent Fraction (Numerator divided by Denominator) Formula – Column I
=IF(F12="",0,F12/G12)
Error Message
#VALUE!
I think the problem has to do with when I an generating a blank entry Column F.
I have an Excel spreadsheet in which a random number and a blank is generated for a Numerator for a Fraction in Column F and a Denominator is generated in Column G using a formula based on the number which is generated in Column F.
When I attempt to generate the resulting value for the fraction in Column I. I am getting an error message of #VALUE!.
What is wrong with the formula I am using?
I want 0.00000 to appear in Column I if Column F is blank.
Numerator Random Number Generator – Column F
=IF(RAND()<0.3," ",RANDBETWEEN(1,63))
Denominator Function – Column G
=IF(F9>=32,64,IF(F9>=16,32,IF(F9>=8,16,IF(F9>=4,8,IF(F9>=2,4,IF(F9>=1,2,0))))))
Decimal Equivalent Fraction (Numerator divided by Denominator) Formula – Column I
=IF(F12="",0,F12/G12)
Error Message
#VALUE!
I think the problem has to do with when I an generating a blank entry Column F.