View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ilia ilia is offline
external usenet poster
 
Posts: 256
Default Nested IF, reports incorrectly, can't find anything like it to

What are the statements?


On Sep 11, 12:56 pm, Chris T-M
wrote:
Duh! Thank you very much.

Now if I can just simplify 21 nested IF statements into 7 I'll be set.



"Michael" wrote:
Try this:
=IF(OR(I54=2,I54=3,I54=4),"Low","")
--
If this posting was helpful, please click on the Yes button.
Regards,


Michael Arch.


"Chris T-M" wrote:


I've boiled down a problem Function to the following statement:
=IF(I54=OR(2,3,4),"Low","")
I54 = 2
Function returns ""- Hide quoted text -


- Show quoted text -