User Profile
ShaeBLE
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Keeping cell blank when using a formula if multiple cells are blank
Hi, I want to keep a cell blank when using a formula based off multiple blank cells, is this possible? Struggled to find anything googling. It's in relation to calculating cbm if that helps. Columns A/B/C are H/W/D (in mm) Column D is formula to calculate cbm CBM calculation is HxWxD, however as I'm using mm I need to divide by 1000 to get m I want the column D to be blank if no data entered in A/B/C but its just giving me #VALUE! or #SPILL! I tried this: =IF(OR(A1=0,B1=0,C1=0),"",((A1/1000)*(B1/1000)*(C1/1000))) Also tried: =IF(ISBLANK(A1:C1=0),"",((A1/1000)*(B1/1000)*(C1/1000))) =IF(A1:C1=0,"",((A1/1000)*(B1/1000)*(C1/1000)))1.1KViews0likes1Comment
Recent Blog Articles
No content to show