| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"If" formula help
Here is the formula I am using...
=IF((C35*0.85-F35-G35+I35)<=0,"0","(C35*0.85-F35-G35+I35)") So, If the answer the the first formula (C35*0.85-F35-G35+I35) is <=0, then it should return 0. THis part works. If the answer to the first formula (C35*0.85-F35-G35+I35) is not <=0, then I want it to return the answer to the forumla C35*0.85-F35-G35+I35. It is simply returning the formula, not the answer. What am I going wrong. I have tried all kinds of things, and can't get it to work... Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If" formula help
Rob, try this, =IF((C35*0.85-F35-G35+I35)<=0,0,(C35*0.85-F35-G35+I35))
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Rob" wrote in message ... Here is the formula I am using... =IF((C35*0.85-F35-G35+I35)<=0,"0","(C35*0.85-F35-G35+I35)") So, If the answer the the first formula (C35*0.85-F35-G35+I35) is <=0, then it should return 0. THis part works. If the answer to the first formula (C35*0.85-F35-G35+I35) is not <=0, then I want it to return the answer to the forumla C35*0.85-F35-G35+I35. It is simply returning the formula, not the answer. What am I going wrong. I have tried all kinds of things, and can't get it to work... Rob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If" formula help
It's not returning a formula. It's just returning a string of text that
looks like your formula. Notice that you have double quotation marks around the formula. Eliminate those: =IF((C35*0.85-F35-G35+I35)<=0,"0",(C35*0.85-F35-G35+I35)) It's also not clear what you intend your calculation to be here. Do you mean for C35*.85 to be calculated and then from that product, subtract F35, G35 and add I35? For auditing purposes in the future, if that's the math you intend you may want to re-write the formula like this: =IF((C35*0.85)-F35-G35+I35)<=0,"0",((C35*0.85)-F35-G35+I35)) Dave -- Brevity is the soul of wit. "Rob" wrote: Here is the formula I am using... =IF((C35*0.85-F35-G35+I35)<=0,"0","(C35*0.85-F35-G35+I35)") So, If the answer the the first formula (C35*0.85-F35-G35+I35) is <=0, then it should return 0. THis part works. If the answer to the first formula (C35*0.85-F35-G35+I35) is not <=0, then I want it to return the answer to the forumla C35*0.85-F35-G35+I35. It is simply returning the formula, not the answer. What am I going wrong. I have tried all kinds of things, and can't get it to work... Rob |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If" formula help
Thanks a ton! Worked perfect... I appreciate your time...
"Paul B" wrote: Rob, try this, =IF((C35*0.85-F35-G35+I35)<=0,0,(C35*0.85-F35-G35+I35)) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Rob" wrote in message ... Here is the formula I am using... =IF((C35*0.85-F35-G35+I35)<=0,"0","(C35*0.85-F35-G35+I35)") So, If the answer the the first formula (C35*0.85-F35-G35+I35) is <=0, then it should return 0. THis part works. If the answer to the first formula (C35*0.85-F35-G35+I35) is not <=0, then I want it to return the answer to the forumla C35*0.85-F35-G35+I35. It is simply returning the formula, not the answer. What am I going wrong. I have tried all kinds of things, and can't get it to work... Rob |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If" formula help
"Rob" wrote in message
... Here is the formula I am using... =IF((C35*0.85-F35-G35+I35)<=0,"0","(C35*0.85-F35-G35+I35)") So, If the answer the the first formula (C35*0.85-F35-G35+I35) is <=0, then it should return 0. THis part works. If the answer to the first formula (C35*0.85-F35-G35+I35) is not <=0, then I want it to return the answer to the forumla C35*0.85-F35-G35+I35. It is simply returning the formula, not the answer. What am I going wrong. I have tried all kinds of things, and can't get it to work... The quote marks tell it to return a text string, so that's what you got (both a text string of zero, and a text string for the formula). Try =IF((C35*0.85-F35-G35+I35)<=0,0,C35*0.85-F35-G35+I35) -- David Biddulph |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If" formula help
Dave, you are also right on, thanks...
"Dave F" wrote: It's not returning a formula. It's just returning a string of text that looks like your formula. Notice that you have double quotation marks around the formula. Eliminate those: =IF((C35*0.85-F35-G35+I35)<=0,"0",(C35*0.85-F35-G35+I35)) It's also not clear what you intend your calculation to be here. Do you mean for C35*.85 to be calculated and then from that product, subtract F35, G35 and add I35? For auditing purposes in the future, if that's the math you intend you may want to re-write the formula like this: =IF((C35*0.85)-F35-G35+I35)<=0,"0",((C35*0.85)-F35-G35+I35)) Dave -- Brevity is the soul of wit. "Rob" wrote: Here is the formula I am using... =IF((C35*0.85-F35-G35+I35)<=0,"0","(C35*0.85-F35-G35+I35)") So, If the answer the the first formula (C35*0.85-F35-G35+I35) is <=0, then it should return 0. THis part works. If the answer to the first formula (C35*0.85-F35-G35+I35) is not <=0, then I want it to return the answer to the forumla C35*0.85-F35-G35+I35. It is simply returning the formula, not the answer. What am I going wrong. I have tried all kinds of things, and can't get it to work... Rob |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If" formula help
"David Biddulph" wrote in message
... "Rob" wrote in message ... Here is the formula I am using... =IF((C35*0.85-F35-G35+I35)<=0,"0","(C35*0.85-F35-G35+I35)") So, If the answer the the first formula (C35*0.85-F35-G35+I35) is <=0, then it should return 0. THis part works. If the answer to the first formula (C35*0.85-F35-G35+I35) is not <=0, then I want it to return the answer to the forumla C35*0.85-F35-G35+I35. It is simply returning the formula, not the answer. What am I going wrong. I have tried all kinds of things, and can't get it to work... The quote marks tell it to return a text string, so that's what you got (both a text string of zero, and a text string for the formula). Try =IF((C35*0.85-F35-G35+I35)<=0,0,C35*0.85-F35-G35+I35) .... but a simpler option is =MAX(C35*0.85-F35-G35+I35,0) -- David Biddulph |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If" formula help
An easier solution =max(0,C35*0.85-F35-G35+I35). If the calculated number is
less than zero - your answer will be zero - else it will be calculated answer "Rob" wrote: Here is the formula I am using... =IF((C35*0.85-F35-G35+I35)<=0,"0","(C35*0.85-F35-G35+I35)") So, If the answer the the first formula (C35*0.85-F35-G35+I35) is <=0, then it should return 0. THis part works. If the answer to the first formula (C35*0.85-F35-G35+I35) is not <=0, then I want it to return the answer to the forumla C35*0.85-F35-G35+I35. It is simply returning the formula, not the answer. What am I going wrong. I have tried all kinds of things, and can't get it to work... Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Formula to sum up data using "if" function?? | Excel Discussion (Misc queries) | |||
| "IF" Formula Query... | Excel Worksheet Functions | |||
| How do I use the "if" and "round" function in the same formula ? | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Linear Mode
