Excel Formula

Joined
Jan 24, 2011
Messages
5
Reaction score
0
Points
1
Hi I have just started to use excel and in the cell if 0 is the answer how do i make blank this is the formula i'm using now but in the cell i get 0 but i want blank if 0 =SUM((B6*C6)+(D6*E6)+(F6*G6)+(H6+I6))
 
Joined
Apr 8, 2012
Messages
25
Reaction score
1
Points
3
Your Mac's Specs
2012 MBP 15"
Try

=if(X1='",",((B6*C6)+(D6*E6)+(F6*G6)+(H6+I6)))

Substitute the destination cell for X1.
 
OP
T
Joined
Jan 24, 2011
Messages
5
Reaction score
0
Points
1
Hi thanks I look all over internet and got to this

=IF(OR((ISBLANK(B6:I6)),SUM(B6*C6)+(D6*E6)+(F6*G6)+H6*I6),"","")

yes then cell is now blank but if I do the sums I need it stay blank and does dont put the answer in the cell
 
OP
T
Joined
Jan 24, 2011
Messages
5
Reaction score
0
Points
1
I try this

=IF((ISBLANK(B6:I6)),"","")*((B6*C6)+(D6*E6)+(F6*G6)+H6*I6)

but now get this #VALUE

why is this so hard and when they give message when the formula wrong it like in double Dutch
 
Joined
May 20, 2004
Messages
243
Reaction score
12
Points
18
Your Mac's Specs
iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB
I try this

=IF((ISBLANK(B6:I6)),"","")*((B6*C6)+(D6*E6)+(F6*G6)+H6*I6)

but now get this #VALUE

why is this so hard and when they give message when the formula wrong it like in double Dutch

Looks like your formula is missing a set of parentheses at the end around H6*I6 so like this:

=IF((ISBLANK(B6:I6)),"","")*((B6*C6)+(D6*E6)+(F6*G6)+(H6*I6))
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top