Hi All,
Having a mare with an IF statement.
Basically I only want the calculation to only show the positive number and display nothing if it's negative. I need more caffeine me thinks..
=IF($AF$2-(AF8+AR8)<0,"",=,SUM($AF$2-(AF8+AR8)))
Any help appreciated.
Thanks, Nick
ThenFormula:
Please Login or Register to view this content.
You don't need SUM or the equals sign. Then just match the brackets.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks, but getting an error still
=IF($AF$2-(AF2+AR2)<0,"",$AF$2-(AF2+AR2))
Brackets match up, looks like it doesn't like ""
Works for me. Have you copied it or typed it? Do your Regional Settings require semi-colons instead of commas?
Yep, changed it. You genius *
Works great...BIG Thanks
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks