| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Set a cell from within a function
I am writing a function to calculate the area of a triangle given the lengths
of the sides. If the inputs are invalid (one side too big), I want the function to set CELL(3,3) to one. Setting CELL(3,3)=1 in the function doesnt work. How can I accomplish this? -- Gary's Student |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Function: Blank cell and 0 (zero) seem to have same "value" | Excel Worksheet Functions | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
| Function to operate on ink linked to cell | Excel Worksheet Functions | |||
| Is there a function to determine whether a cell contains a formul. | Excel Worksheet Functions | |||
| Excel - option to extend function in cell to column | Excel Worksheet Functions | |||
Threaded Mode
