How do I condition a formula to reflect a positive balance?
ie: =6000-B30 displays remaining goal balance but if the goal has been exceeded the cell displays a negative balance. I would like to condition it to display a positive balance once the goal total of 6000 has been exceeded.
Please help!!!
Thank you
Last edited by suzy~wow; 12-22-2008 at 08:53 AM.
This formula will display zero if B30 > 6000
=MAX(0,6000-B30)
Please help!!
Last edited by suzy~wow; 12-21-2008 at 05:19 PM.
I would like to cell to represent a positive number if the 6000 goal has been exceeded instead of a negetive or 0.
Thank you
So if B30 is 7000 you want to show 1000? Try
=ABS(B30-6000)
YES! You Are the Master!
Thank you so much!
BTW??? What does ABS stand for?
Absolute value.
Help is your friend, Suzy.
Would you please mark the thread as solved?
To mark a thread as solved:
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
If more than two days have elapsed since your first post, ask a moderator to mark it.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks