Neting OR and AND in IF statement

**Pr0** · 06-29-2022, 01:25 PM

Hi.

I've got this formula:

=IF(OR((B2+C2)=0; AND(B2="—"; C2="—")); ""; (B2+C2)/2)

but it returns a #VALUE! error.
I can´t quite figure out what the problem is.
File attached.

PR

**JohnTopley** · 06-29-2022, 01:30 PM

Try

=IF(AND(B2="—",C2="—"),"",IF((B2+C2)=0,"",(B2+C2)/2))

but why use "—" ?

**Pr0** · 07-01-2022, 07:45 AM

A cell with a "—" and an empty cell have different meanings for what I want to do.
That solves it.
Thank you.

PR

Neting OR and AND in IF statement

LinkBack

Thread Tools

Rate This Thread

Display

Neting OR and AND in IF statement

Re: Neting OR and AND in IF statement

Re: Neting OR and AND in IF statement

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] IF Statement with Multi-Criteria Statement inside a Data Validation List

[SOLVED] i have an if then statement that works, how to make it work as a with or case statement

compile error expected line number statement end statement

VBA Compile Error : line number or label or statement or end of statement

[SOLVED] Convert If statement with cell row reference calculations to vlookup statement

VBA- Compile Error, Expected: line number or label or statement or end of statement

[SOLVED] Utilize a Select Case Statement in Target Intersect Statement

Bookmarks

Bookmarks

Posting Permissions