| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function writing help
Trying to figure out how to write a function for the following issue:
I want to have a cell that reads from another (first) cell the number and then report action based on the number in the first cell. It needs to consider first if the cell has a 0 in it should then report a 0, If it is not a 0 it then needs to run the equation 269.9+(9.538*F7). The function I have at this point is =IF(D7=0, "0","269.9+(9.538*F7)") the problem is that the first part works and it reports 0 as it should but if I put another number in get the equation printed rather than it running the equation. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function writing help
"=IF(D7=0, "0","269.9+(9.538*F7)")"
Remove *all* the quotes from the formula: =IF(D7=0,0,269.9+9.538*F7) -- Biff Microsoft Excel MVP "Gator" wrote in message ... Trying to figure out how to write a function for the following issue: I want to have a cell that reads from another (first) cell the number and then report action based on the number in the first cell. It needs to consider first if the cell has a "0" in it should then report a "0", If it is not a "0" it then needs to run the equation "269.9+(9.538*F7)". The function I have at this point is "=IF(D7=0, "0","269.9+(9.538*F7)")" the problem is that the first part works and it reports "0" as it should but if I put another number in get the equation printed rather than it running the equation. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function writing help
Hi,
Ditch the quotes around the numbers is making them text =IF(D7=0, 0,269.9+(9.538*F7)) Mike "Gator" wrote: Trying to figure out how to write a function for the following issue: I want to have a cell that reads from another (first) cell the number and then report action based on the number in the first cell. It needs to consider first if the cell has a 0 in it should then report a 0, If it is not a 0 it then needs to run the equation 269.9+(9.538*F7). The function I have at this point is =IF(D7=0, "0","269.9+(9.538*F7)") the problem is that the first part works and it reports 0 as it should but if I put another number in get the equation printed rather than it running the equation. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WRITING A WHAT IF FUNCTION | Excel Worksheet Functions | |||
| Writing UDF Help | Excel Discussion (Misc queries) | |||
| Why doesn't writing a nested IF function work? | Excel Discussion (Misc queries) | |||
| Help Writing Function | Excel Worksheet Functions | |||
| Writing to csv | Excel Discussion (Misc queries) | |||
Linear Mode
