Results 1 to 2 of 2

Thread: orfunction for text?

  1. #1

    orfunction for text?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    =IF(C4="W";D4+D5;"") sums d4 and d5 numbers because they are date and time and i need one number. in C column there are "w" and "l" and also some other stuff.
    now i am doing two different columns first =IF(C4="W";D4+D5;"") in column J and =if(c4="l";d4+d5) in next column k.

    is there a way to write if function with OR like =IF(C4=OR("w";"l");D4+D5;"") so i dont have to make 2 columns?

    why does this return VALUE error?

  2. #2
    Try

    =IF(OR(C4="w";C4="l");D4+D5;"")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •