| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula Help
I am trying to write a formula contained in cell V5 of my spreadsheet as
follows: =F5-(F5*C5)+T5). However what i want to also include is if the value returned in V5 = T5 replace with "0.0000" how do i do that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula Help
Hi,
=if(F5-(F5*C5)+T5=T5,"0.0000",F5-(F5*C5)+T5) "jmilholland" wrote: I am trying to write a formula contained in cell V5 of my spreadsheet as follows: =F5-(F5*C5)+T5). However what i want to also include is if the value returned in V5 = T5 replace with "0.0000" how do i do that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula Help
Thank you!
"Eduardo" wrote: Hi, =if(F5-(F5*C5)+T5=T5,"0.0000",F5-(F5*C5)+T5) "jmilholland" wrote: I am trying to write a formula contained in cell V5 of my spreadsheet as follows: =F5-(F5*C5)+T5). However what i want to also include is if the value returned in V5 = T5 replace with "0.0000" how do i do that? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula Help
The formula you posted is missing a parenthesis somewhere. I will make an
assumption regarding its placement... =IF(F5-((F5*C5)+T5)=T5,0,F5-((F5*C5)+T5)) And format cell to display 4 decimals. If you don't want to format the cell to 4 decimals and don't mind have a text string returned, you could change formula to: =IF(F5-((F5*C5)+T5)=T5,"0.0000",F5-((F5*C5)+T5)) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "jmilholland" wrote: I am trying to write a formula contained in cell V5 of my spreadsheet as follows: =F5-(F5*C5)+T5). However what i want to also include is if the value returned in V5 = T5 replace with "0.0000" how do i do that? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula Help
Thank you!
"Luke M" wrote: The formula you posted is missing a parenthesis somewhere. I will make an assumption regarding its placement... =IF(F5-((F5*C5)+T5)=T5,0,F5-((F5*C5)+T5)) And format cell to display 4 decimals. If you don't want to format the cell to 4 decimals and don't mind have a text string returned, you could change formula to: =IF(F5-((F5*C5)+T5)=T5,"0.0000",F5-((F5*C5)+T5)) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "jmilholland" wrote: I am trying to write a formula contained in cell V5 of my spreadsheet as follows: =F5-(F5*C5)+T5). However what i want to also include is if the value returned in V5 = T5 replace with "0.0000" how do i do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Hybrid Mode
