Thread
:
Need a little help please.
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Need a little help please.
You will need a combination of AND & OR. try this
=IF(OR(AND(B2="s",C211),AND(C222,OR(B2="o",B2="u "))),"c","N")
--
Don Guillett
SalesAid Software
"hotdog6660" wrote
in message ...
Hello.
I am putting together a spreadsheet but have struggled to get past this
final stage
Basically I have a spreadsheet which will show across a row.
A B
C
user name Ref (which will be O, S, or U) a number of days
between 2 dates.
I need a formula which will "look" at whether cell in B is U, S, or O.
It also has to "look" at whether the days in cell C is above 22 for (O
or U) or above 11 for S
If the criteria is above these amounts the cell will display a message
"Call HR"
If it is below these levels it will display "no action"
Any help is very much obliged
hotdog
--
hotdog6660
------------------------------------------------------------------------
hotdog6660's Profile:
http://www.excelforum.com/member.php...o&userid=37869
View this thread:
http://www.excelforum.com/showthread...hreadid=574146
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett