Chris

Posts: n/a

How do I create complex functions?

I need to create a formula that can recognize when the cell is 0.

For instance: If C125 is Greater than 0 perform function as follows
(=c125*2.75%+0.30) if it is equal to 0 then results should be 0.

Can this be done? If so what is the function to perform this task?

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
create invoices	Missie	New Users to Excel	6	January 23rd 05 01:05 PM
PivotTable canned functions	doco	Excel Discussion (Misc queries)	0	January 14th 05 03:52 PM
Changing the language of built-in functions?	Gustaf Liljegren	New Users to Excel	3	December 20th 04 08:31 PM
trying to create	Lost in reconcillation	Excel Discussion (Misc queries)	2	December 19th 04 01:05 AM
Use Julian Date To Create Serial Number	antho10359	Excel Discussion (Misc queries)	4	December 9th 04 01:50 AM

All times are GMT +1. The time now is 03:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us