LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default IF formula to accept or reject based on numbers entered.

Im trying to set up a spreadsheet that will indicate whether or not multiple
values are acceptable or rejectable for percentages entered for a single
line.

For example....

Percentages entered into A3, B3, and C3 needs to be between 3.0 and 5.0.....
if the percentage entered is 2.9 or below / 5.1 or above in any cell, it will
automatically fill in E3 with an "X". And if any percentage entered is
between 3.0 and 5.0 it will fill in D3 with an "X".

Something like this. (as best as I could describe it)

A B C D
E
1 Element 1 Element2 Element3
2 3.0 - 5.0 3.0 - 5.0 3.0 - 5.0 A R
3 2.8 4.5 4.9 X
4 3.5 4.1 3.9 X

I was able to accomplish this a long time ago, however it was several years
ago and I dont have the first clue as to how I managed to accomplish it
before.

Can anyone please help?????
 
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
Format cell to accept only specific character-reject others aetzkin Excel Discussion (Misc queries) 2 December 27th 05 05:03 PM
In a shared workbook, can only one person "accept or reject" chang pama Excel Discussion (Misc queries) 0 September 8th 05 01:45 PM
can only one person accept or reject changes in a shared workbook? pama Excel Discussion (Misc queries) 0 September 7th 05 07:33 PM
Disable Accept/Reject Changes tjtjjtjt Excel Discussion (Misc queries) 0 April 20th 05 07:26 PM
Formula to calucate # of months based on a speificed date entered David Excel Worksheet Functions 4 December 15th 04 06:57 PM


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

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"