| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
I am trying to find a value of a cell. I keep recieving error messages #Name?
If I19 is yes then I want it to calculate a value using (D15/52)*60% If I19 is no then I want the cell to show"0" IF(I19=yes,(((D15/52)*0.6)),"0") Any suggestions? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
Put the yes value within double quotes
=IF(I19="yes",D15/52*0.6,"0") "cwilliams" wrote: I am trying to find a value of a cell. I keep recieving error messages #Name? If I19 is yes then I want it to calculate a value using (D15/52)*60% If I19 is no then I want the cell to show"0" IF(I19=yes,(((D15/52)*0.6)),"0") Any suggestions? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
Try this:
=IF(I19="yes",(D15/52)*0.6,0) In quotes, Excel interprets "yes" as simple text. Without the quotes, it looks for a function or range with that name. Does that help? *********** Regards, Ron XL2002, WinXP "cwilliams" wrote: I am trying to find a value of a cell. I keep recieving error messages #Name? If I19 is yes then I want it to calculate a value using (D15/52)*60% If I19 is no then I want the cell to show"0" IF(I19=yes,(((D15/52)*0.6)),"0") Any suggestions? Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
That was it. Thanks guys!!!!!
"Ron Coderre" wrote: Try this: =IF(I19="yes",(D15/52)*0.6,0) In quotes, Excel interprets "yes" as simple text. Without the quotes, it looks for a function or range with that name. Does that help? *********** Regards, Ron XL2002, WinXP "cwilliams" wrote: I am trying to find a value of a cell. I keep recieving error messages #Name? If I19 is yes then I want it to calculate a value using (D15/52)*60% If I19 is no then I want the cell to show"0" IF(I19=yes,(((D15/52)*0.6)),"0") Any suggestions? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
