| Home |
| Search |
| Today's Posts |
|
#5
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 |
| 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 | |||
Threaded Mode
