neil@snowandjones

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
Excel Range Value issue (Excel 97 Vs Excel 2003)	Keeno	Excel Discussion (Misc queries)	2	June 13th 05 02:01 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
How to create specific formula	STS	Excel Worksheet Functions	4	May 2nd 05 01:44 AM
Create an if-then formula in Excel to limit column total?	Nancy M	Excel Discussion (Misc queries)	2	February 13th 05 10:47 PM

All times are GMT +1. The time now is 01:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us