LinkBack URL
About LinkBacks
=IFERROR((SUM(F18*0.45)=0," ",SUM(F18*0.45)), " ")
I want the formula to do SUM F18*0.45. If the value is "0" I want the cell to be blank.
And also if there is an error within the cell for it also to be blank.
Any help is appreciated. Cheers
What is wrong with my formula?
=IFERROR((SUM(F18*0.45)=0," ",SUM(F18*0.45)), " ")
I want the formula to do SUM F18*0.45. If the value is "0" I want the cell to be blank.
And also if there is an error within the cell for it also to be blank.
Any help is appreciated. Cheers
...maybe
=IFERROR(F18*0.45,"")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
You're missing the IF Function
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
Try:Formula:
Please Login or Register to view this content.
Thanks, this works!Originally Posted by TMS
Try:Formula:Please Login or Register to view this content.
Can I ask... how come the =sum is no longer needed? Was that what was messing things up?
You're not summing anything, you're multiplying a cell by a value. But no, that would still work, it's just not necessary. As I said, you were missing the IF.
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks