|
So basically, If there are formulas in the entries where you do not want the value to go below 0, take the formula you already had, and add it into cyrnel's above formula at the (a1:b4) locations and replace whats in the parenthesis with your formula. You won't lose your numbers, it just kinda filters them so if the values do go below 0, it just shows 0.
__________________
"This visage, no mere veneer of vanity, is it vestige of the vox populi, now vacant, vanished, as the once vital voice of the verisimilitude now venerates what they once vilified. However, this valorous visitation of a by-gone vexation, stands vivified, and has vowed to vanquish these venal and virulent vermin vanguarding vice and vouchsafing the violently vicious and voracious violation of volition. The only verdict is vengeance; a vendetta, held as a votive, not in vain, for the value and veracity of such shall one day vindicate the vigilant and the virtuous. Verily, this vichyssoise of verbiage veers most verbose vis-à-vis an introduction, and so it is my very good honor to meet you and you may call me V." - V
|