|
If statement
I am trying to create an if statement that checks 5 different cells and if
they are empty, i want it to display "Missing total" if none of them are empty i want it to sum them. How? -- Message posted via http://www.officekb.com |
If statement
=IF(AND(ISBLANK(A1),ISBLANK(A2),ISBLANK(A3),ISBLAN K(A4),ISBLANK(A5)),"Missing
total",SUM(A1:A5)) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "brownti via OfficeKB.com" wrote: I am trying to create an if statement that checks 5 different cells and if they are empty, i want it to display "Missing total" if none of them are empty i want it to sum them. How? -- Message posted via http://www.officekb.com |
If statement
On Feb 20, 5:10 pm, "brownti via OfficeKB.com" <u31540@uwe wrote:
I am trying to create an if statement that checks 5 different cells and if they are empty, i want it to display "Missing total" if none of them are empty i want it to sum them. How? -- Message posted viahttp://www.officekb.com assuming you are having your five values in a1:e1 enter in any cell in your sheet: =IF(COUNTIF(A1:E1;"")0;"Missing Total";SUM(A1:E1)) hope, that's what you were looking for... have a nice day Michael (http://bereichverschieben.blogspot.com) |
If statement
On Feb 20, 5:17 pm, wrote:
On Feb 20, 5:10 pm, "brownti via OfficeKB.com" <u31540@uwe wrote: I am trying to create an if statement that checks 5 different cells and if they are empty, i want it to display "Missing total" if none of them are empty i want it to sum them. How? -- Message posted viahttp://www.officekb.com assuming you are having your five values in a1:e1 enter in any cell in your sheet: =IF(COUNTIF(A1:E1;"")0;"Missing Total";SUM(A1:E1)) hope, that's what you were looking for... have a nice day Michael (http://bereichverschieben.blogspot.com) you might have to replace my semicolons by comma...sorry - german keyboard |
| All times are GMT +1. The time now is 02:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com