| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
create a formula in excel to prevnt negative
here is my formula to show in cell E4 =(A4*0.02)+((C4-A4)*0.03)
However, i do not want to calculation made if the value of C4 is less than the value of A4. For the purposes of this result, this will make an invalid result. |
|
#2
|
|||
|
|||
|
Hi
Try this: =MAX((A4*0.02)+((C4-A4)*0.03),0) Andy. "neil@snowandjones" wrote in message ... here is my formula to show in cell E4 =(A4*0.02)+((C4-A4)*0.03) However, i do not want to calculation made if the value of C4 is less than the value of A4. For the purposes of this result, this will make an invalid result. |
|
#3
|
|||
|
|||
|
=IF(C4<A4,"",(A4*0.02)+((C4-A4)*0.03))
-- Ian -- "neil@snowandjones" wrote in message ... here is my formula to show in cell E4 =(A4*0.02)+((C4-A4)*0.03) However, i do not want to calculation made if the value of C4 is less than the value of A4. For the purposes of this result, this will make an invalid result. |
|
#4
|
|||
|
|||
|
Thanx Ian.
Worked a charm Neil. "Ian" wrote: =IF(C4<A4,"",(A4*0.02)+((C4-A4)*0.03)) -- Ian -- "neil@snowandjones" wrote in message ... here is my formula to show in cell E4 =(A4*0.02)+((C4-A4)*0.03) However, i do not want to calculation made if the value of C4 is less than the value of A4. For the purposes of this result, this will make an invalid result. |
|
#5
|
|||
|
|||
|
No problem. Thanks for the feedback.
-- Ian -- "neil@snowandjones" wrote in message ... Thanx Ian. Worked a charm Neil. "Ian" wrote: =IF(C4<A4,"",(A4*0.02)+((C4-A4)*0.03)) -- Ian -- "neil@snowandjones" wrote in message ... here is my formula to show in cell E4 =(A4*0.02)+((C4-A4)*0.03) However, i do not want to calculation made if the value of C4 is less than the value of A4. For the purposes of this result, this will make an invalid result. |
|
#6
|
|||
|
|||
|
Sorry! I read your subject and not your post!
Andy. "neil@snowandjones" wrote in message ... here is my formula to show in cell E4 =(A4*0.02)+((C4-A4)*0.03) However, i do not want to calculation made if the value of C4 is less than the value of A4. For the purposes of this result, this will make an invalid result. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How to create specific formula | Excel Worksheet Functions | |||
| Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) | |||
Hybrid Mode
