Getting Rid of the #DIV/0! Cell Value

[atvsource]

I'm getting the dreaded #DIV/0! value. Here's the formula I'm using:

=IF($B$20>=E6,"Budget",ROUNDUP((E6-$B$20)/$B$21,0))

I've tried to fix this, but I only seem to get the VALUE text to show up for all the things I've tried.

Anyone have a suggestion?

Here's what the different cells represent:
B20 = Investible Amount
E6 = Actual Price
B21 = Passive Income

 

[c_m]

Try:
=IF($B$21=0,"",IF($B$20>=E6,"Budget",ROUNDUP((E6-$B$20)/$B$21,0)))

 

[VoG]

Try

=IF($B$21="","",IF($B$20>=E6,"Budget",ROUNDUP((E6-$B$20)/$B$21,0)))

 

[atvsource]

That didn't seem to work.. the #DIV/0! is still returning.

 

[c_m]

ADVERTISEMENT

do you have div!0 error in B20 or B21?

 

[atvsource]

Nope, however, B21 has a value of $0.00 sometimes so would that $0.00 in B21 cause teh #DIV/0! issue?

 

[c_m]

ADVERTISEMENT

yes B21 will cause this issue...did you try the suggested formula:
=IF($B$21=0,"",IF($B$20>=E6,"Budget",ROUNDUP((E6-$B$20)/$B$21,0)))

 

[atvsource]

yes B21 will cause this issue...did you try the suggested formula:
=IF($B$21=0,"",IF($B$20>=E6,"Budget",ROUNDUP((E6-$B$20)/$B$21,0)))

Tried this formula, but now when B20 is greater than E6, Budget does not show up, but instead a blank cell. So something else is also wrong with the formula.

 

[atvsource]

Tried this formula, but now when B20 is greater than E6, Budget does not show up, but instead a blank cell. So something else is also wrong with the formula.

After some fig'n with the formula, I was able to get it to work.. there was another issue with another formula that this also had to work with. After fixing the other formula, it all works great now.

Thanks for all the help!! Saved me a lot of time!