Share via

Excel formula with multiple conditions and an exception

Anonymous
2018-07-11T10:30:57+00:00

So i have a working formula im trying to add a exception to: =IF(A4="vr","8",IF(OR(A4="za",A4="zo"),"24","16"))

I'm trying to add the exception that it shows a blank value if D4 says "OVD" not sure if this is possible but help would be appreciated, thanks in advance!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. DaveM121 816.5K Reputation points Independent Advisor
    2018-07-11T10:35:55+00:00

    Hi Luukvan, here you go:

    =IF(D4="OVD", "", IF(A4="vr","8",IF(OR(A4="za",A4="zo"),"24","16")))

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-07-11T10:40:35+00:00

    Hello Luukvan. Here is what I came up with on your IF statement. =IF(OR(A4="za",A4="zo"),24,IF(A4="vr",8,16))

    Please test and let me know if this is correct. I would like to point out one thing from your if statement. Do you want 8, 16, and 24 to be text? You have them in quotes. I made them all numbers in my formula. One screenshot is attached also.

    0 comments
  2. Anonymous
    2018-07-11T10:43:14+00:00

    I forgot about your OVD. Dave M's formula is correct! Use it.

    0 comments