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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value expression
Try this
=if(e9<0,0,(e9*50)+10 ) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "RayB" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value expression
=if(e9<0,0,e9*50+10)
Does your formula REALLY have the 10 in quotes? Get rid of them. "RayB" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value expression
Ray,
=if(e90,e9*50+10,0) This is based on the assumption that this formula is being place in cell F9 -- http://HelpExcel.com "RayB" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value expression
Thank You! I'm obviously a novice, and kept getting errors - I greatly
appreciate your help and quick responses. Ray B. "galimi" wrote: Ray, =if(e90,e9*50+10,0) This is based on the assumption that this formula is being place in cell F9 -- http://HelpExcel.com "RayB" wrote: 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value expression
maybe this will not confuse me
=--(E90)*(E9*50+10) -- ***** birds of the same feather flock together.. "RayB" wrote: 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value expression
driller,
=--(E90)*(E9*50+10) In this case you don't need the double unary to coerse the TRUE/FALSE (E90) into 1 or zero, the multiplication will do it for you -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "driller" wrote in message ... maybe this will not confuse me =--(E90)*(E9*50+10) -- ***** birds of the same feather flock together.. "RayB" wrote: 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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value expression
thats right sandymann
=(e90)*(e9*50+10) -- ***** birds of the same feather flock together.. "Sandy Mann" wrote: driller, =--(E90)*(E9*50+10) In this case you don't need the double unary to coerse the TRUE/FALSE (E90) into 1 or zero, the multiplication will do it for you -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "driller" wrote in message ... maybe this will not confuse me =--(E90)*(E9*50+10) -- ***** birds of the same feather flock together.. "RayB" wrote: 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. |
Reply |
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) |