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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 01:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com