| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement
=IF(COUNT(A1:E1)<5,"missing",SUM(A1:E1))
-- Don Guillett SalesAid Software "brownti via OfficeKB.com" <u31540@uwe wrote in message news:6e183d2f3ea52@uwe... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| IF statement | Excel Worksheet Functions | |||
| if statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
