sum with hide error value

[jack999]

I want to sum and multiply value as given below. I would like to hider #value if some column contain no value


Rate stock1 stock2 stock3 Amount

25 50 75

60 15 10 35


I want to multiply stock1,stock2,stock3 * rate to amount column with hide error value.

 

[srinidhi]

This can be done with conditional formatting.

 

[jack999]

I GOT FORMULA SUPPOSE STOCK1,STOCK2,STOCK3 AT J4,K4,L4 CELL AND RATE ON I4 CELL THEN


=IF(COUNT(J4:L4)=3,J4+K4+L4)*I4


IF ANY ONE CAN ANY OTHER FORMULA THEN GIVE ME

 

[nazmul_muneer]

Dear Jack999

If you write this formula =(J4+K4+L4)*I4 why it returns error?


Regards,


Muneer