Posted to microsoft.public.excel.programming

external usenet poster

Posts: 18

Need some help writing code.

I have a couple of formulas that I would like to replace with a sub. This is beyond my capabilities however. Any suggestions are appreciated. The formulas follow

=IF(ISBLANK(B22),"",IF(ISBLANK(B23),"",IF((B22-B23=0),"Met",IF((B22-B23<0),"Over","Under")))

=IF(ISBLANK(B22),"",IF(ISBLANK(B23),"",IF((B22-B23<0),-(B22-B23),IF((B22-B23=0),"",B22-B23))))

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
IS IT POSSIBLE IN EXCEL WITHOUT WRITING CODE.	HARSHAWARDHAN. S .SHASTRI[_2_]	Excel Worksheet Functions	14	February 4th 09 04:48 PM
Need help writing Code	LeAnne	Excel Discussion (Misc queries)	1	February 15th 08 03:27 PM
Code writing:Where to start ?	MIke	Excel Programming	2	February 19th 04 08:46 PM
Writing a formula in code	Tom Ogilvy	Excel Programming	0	September 5th 03 02:32 PM
Please help Frustrating VBA code writing problem	[email protected]	Excel Programming	1	August 7th 03 05:23 PM

All times are GMT +1. The time now is 12:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us