| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then statements
Based on a financial condition calculated in a cell, I either want to display
an alpha numberic result or want to run another calculation and show that result in the cell. How is that done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then statements
BC
=IF(financial condition calculated in a cell, alpha numberic result, run another calculation and show that result in the cell) for example: =IF(A110,"Your financial condition is true",A1*8.5) or =IF(A110,A1*7.5,"Your financial condition is false") HTH, Conan Kelly "BC" wrote in message ... Based on a financial condition calculated in a cell, I either want to display an alpha numberic result or want to run another calculation and show that result in the cell. How is that done? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then statements
=IF(A1="Something","Alphanumeric",calculation here)
-- Regards, PJ Please rate this post using the vote buttons if it was helpful. "BC" wrote: Based on a financial condition calculated in a cell, I either want to display an alpha numberic result or want to run another calculation and show that result in the cell. How is that done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statements | Excel Worksheet Functions | |||
| If Statements | Excel Discussion (Misc queries) | |||
| Dim statements in VBA | Excel Discussion (Misc queries) | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| How to Sum with two if statements | Excel Worksheet Functions | |||
Linear Mode
