Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 5

Excel 2007 - Multiple If Then or Lookup

I'm trying to check cells K5 or K6 or K7 or K8 or K9 for the presence of the
letter "x" and if "True" to multiply cell H5 by the appropriate percentage
and then add cell I5 to the total. Additionally, I need to simultaneously
check cell K10 for the letter "x" and if TRUE then the previous total needs
to be multiplied by .95

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
Sum Result of lookup in excel 2007	David Ryan	Excel Worksheet Functions	5	April 1st 09 09:55 AM
Lookup Function for Excel 2007	Cornelius	Excel Discussion (Misc queries)	2	March 6th 09 12:44 AM
Excel 2007 lookup problem continuing ...	Trish	Excel Worksheet Functions	3	August 5th 08 05:46 AM
Excel 2007 Lookup	Trish	Excel Worksheet Functions	4	July 23rd 08 06:29 AM
Excel 2007 LOOKUP Problem?	robertbjr	Excel Worksheet Functions	3	March 18th 08 06:32 PM

All times are GMT +1. The time now is 04:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us