Thread
:
value expression
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
RayB
external usenet poster
Posts: 8
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.
Reply With Quote
RayB
View Public Profile
Find all posts by RayB