| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Warning text triggered by values of a cell range
I'm doing something wrong and can't figure it out. Can anybody help me?
Heres what I want: If user enter value in cells A1 through A5, I want cell A6 to return €śMust be filled in€ť Heres the formula I put in A6: =IF(A10,"Must be filled in!","") and it works, but only for one reference cell. What I want is a range of cells (A1:A5). So I enter in A6: =IF(A1:A50,"Must be filled in!",""). And I get a #VALUE! Error in A6. Help! -- Merci! Bonzai |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Warning text triggered by values of a cell range
=if(count(a1:a5)=5,"Must be filled in","")
if you enter numbers in a1:a5 =if(counta(a1:a5)=5,"Must be filled in","") if you enter numbers or text in A1:A5 I would put the formula in B6, though and use a formula like: =if(and(count(a1:a5)=5,a6=""),"A6 Must be filled in","") Bonzai wrote: I'm doing something wrong and can't figure it out. Can anybody help me? Heres what I want: If user enter value in cells A1 through A5, I want cell A6 to return €śMust be filled in€ť Heres the formula I put in A6: =IF(A10,"Must be filled in!","") and it works, but only for one reference cell. What I want is a range of cells (A1:A5). So I enter in A6: =IF(A1:A50,"Must be filled in!",""). And I get a #VALUE! Error in A6. Help! -- Merci! Bonzai -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Warning text triggered by values of a cell range
It works! Thank You Dave for taking the time to help me, I appreciate it!
Merci Beaucoup! -- Bonzai "Dave Peterson" wrote: =if(count(a1:a5)=5,"Must be filled in","") if you enter numbers in a1:a5 =if(counta(a1:a5)=5,"Must be filled in","") if you enter numbers or text in A1:A5 I would put the formula in B6, though and use a formula like: =if(and(count(a1:a5)=5,a6=""),"A6 Must be filled in","") Bonzai wrote: I'm doing something wrong and can't figure it out. Can anybody help me? Here's what I want: If user enter value in cells A1 through A5, I want cell A6 to return "Must be filled in" Here's the formula I put in A6: =IF(A10,"Must be filled in!","") and it works, but only for one reference cell. What I want is a range of cells (A1:A5). So I enter in A6: =IF(A1:A50,"Must be filled in!",""). And I get a #VALUE! Error in A6. Help! -- Merci! Bonzai -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Warning text triggered by values of a cell range
Da Nada
Bonzai wrote: It works! Thank You Dave for taking the time to help me, I appreciate it! Merci Beaucoup! -- Bonzai "Dave Peterson" wrote: =if(count(a1:a5)=5,"Must be filled in","") if you enter numbers in a1:a5 =if(counta(a1:a5)=5,"Must be filled in","") if you enter numbers or text in A1:A5 I would put the formula in B6, though and use a formula like: =if(and(count(a1:a5)=5,a6=""),"A6 Must be filled in","") Bonzai wrote: I'm doing something wrong and can't figure it out. Can anybody help me? Here's what I want: If user enter value in cells A1 through A5, I want cell A6 to return "Must be filled in" Here's the formula I put in A6: =IF(A10,"Must be filled in!","") and it works, but only for one reference cell. What I want is a range of cells (A1:A5). So I enter in A6: =IF(A1:A50,"Must be filled in!",""). And I get a #VALUE! Error in A6. Help! -- Merci! Bonzai -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions- Finding and counting specified text in cell range | Excel Worksheet Functions | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| 25 days previous to today? | Excel Discussion (Misc queries) | |||
| Warning while entering duplicate values in a cell | Excel Discussion (Misc queries) | |||
| Inserting two cell values into a new cell + text | Excel Discussion (Misc queries) | |||
Linear Mode
