I'm trying to get a cell (B8) to display a '0' or the word 'Nil' when a minus figure is arrived at with the formula =SUM(B6-B9) i.e if B6 contains £7392.00 and B9 contains £12,320.00, I need '0' or 'Nil' to display rather than -£4928.00 any ideas please??
Last edited by Illustris13; 04-05-2013 at 06:05 PM.
=MAX(B6-B9,0)
FYI, you do not need SUM when you are performing mathematical operations such as B6-B9, the formula would just be =B6-B9
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
You could try:
=IF((B6-B9)<0,"Nil",B6-B9)
If I've been of help, please hit the star
Many thanks to both of you guys for the invaluable help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks