| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula for # names listed * $5
I have one column, 30 lines. LINES WITH NAMES PAY $5. Need a formula that
will give include all thirty lines with names but only give a result for the lines with names. So that whenever names are added I won't have to redo the formula each time. msexcel2003 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need formula for # names listed * $5
Do you mean
=COUNTA(A1:A30)*5 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "elleneII" wrote in message ... I have one column, 30 lines. LINES WITH NAMES PAY $5. Need a formula that will give include all thirty lines with names but only give a result for the lines with names. So that whenever names are added I won't have to redo the formula each time. msexcel2003 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need formula for # names listed * $5
Hi,
Something like =if(A1<"",5,0) HTH Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking portions of a formula | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Linear Mode
