I'm getting the dreaded #DIV/0! value. Here's the formula I'm using:
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
Code:
=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