Posted to microsoft.public.excel.worksheet.functions

Crazymom999

Posts: n/a

=If - how to tell it to calc certain %'s only

Hi, Please help. I am trying to get Excel to calculate the following.
A1 = 11.8% A2 = 12.8% A3 = 11.67%
b1 = Â£20 b2 = Â£30 b3 = Â£18

Only to calculate any 'Â£' between 11.5% -12.00% = Â£38.

Please help - hours later and my head is spinning! Thanks in advance,
Crazymom999

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
Pivot Tbl Calc Field using %'s	gramos14	Excel Discussion (Misc queries)	4	April 3rd 06 03:25 AM
Apply a formula as a pivot table calc or suggestion	Todd F.	Excel Worksheet Functions	2	March 30th 06 02:22 AM
Calc RSQ and exclude zeros	Bruce	Excel Worksheet Functions	3	January 19th 06 01:01 PM
Formula for calc diff between two julian dates	saltrm	Excel Discussion (Misc queries)	1	November 7th 05 08:00 PM
easy calc excell	titont	Excel Discussion (Misc queries)	3	March 12th 05 07:50 AM

All times are GMT +1. The time now is 05:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us