| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value expression
I have a formula that states =(e9*50)+"10"
I'd like to make this formula conditional where it only does calculates the formula if e9 0 so.. how do you do a simple "if" statement please? ( if e9<0 then F9=0 else F9 = (e9*50)+10 ) is what I'm trying to accomplish. Thanks! RayB. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return the row # of an expression in specific array of cell | Excel Worksheet Functions | |||
| Expression for Macro - help | Excel Discussion (Misc queries) | |||
| Excel expression {=SUm(if(istext(c8:k8),1,0))} | Excel Worksheet Functions | |||
| Can Excel represent formula in textural format with values substi. | Excel Worksheet Functions | |||
| Excel Expression | Excel Discussion (Misc queries) | |||
Threaded Mode
