=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
=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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks