LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Conditional Formula

Hello,

I would like to add cell a1 and b1 only if the totals of three other cells
are within a specific parameter.

For example; if my formula is is cell d1 and it is looking at m1 and the
result of m1 are 0 - 5, or 35 - 45, or 75 to 85, then I would like for d1
then to add cell a1 and b1. If m1 has any other result I do not want d1 to
take any action (remain 0).

Thanks for the help
Jim


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Conditional Formula JamieWPS Excel Discussion (Misc queries) 2 May 14th 07 08:00 PM
conditional formula pattyling Excel Worksheet Functions 4 March 1st 07 10:18 PM
Conditional Formula help Richard Excel Discussion (Misc queries) 4 September 26th 06 05:23 PM
Conditional Formula to indicate Formula in cell SteveW New Users to Excel 9 August 2nd 06 01:12 AM
conditional formula Beth104 Excel Discussion (Misc queries) 2 March 8th 06 09:51 AM


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"