logic test with 2 conditions Solved

Question

Hello,

in Excel, I want to perform a logical test (IF condition)

IF (a = field; or = "") = ""

IF (a # field; or# "" ) = 1

Thank you for your responses

Configuration: Windows Vista / Firefox 7.0

Heremion · Accepted Answer

Hello Raveno39,   =IF(OR(A1=5;A1="");"";0) =IF(OR(A15;A1"");1;0) -- You should always consider accepting a post that gets you out of trouble

Bruce Willix · Answer

We must use the AND operator and the IF formula combined. for the rest, your question already gives its own answer.   -- He is not a sales representative: he’s your dad!

raveno39 · Answer

I showed you in image what I wanted because I tried the formulas that were put, they don’t work if I replace the numbers with names

[link=https://www.casimages.com/i/110922020859580453.jpg.html' target='_blank' rel='nofollow noopener noreferrer'>https://www.casimages.com/i/110922020859580453.jpg.html][img]http://nsa27.casimages.com/img/2011/09/22/mini_110922020859580453.jpg[/img][/url]

thank you

Heremion · Answer

I can get the same result when I put the formula in a column and stretch it across rows.

=IF(OR(CurrentRowCell="red";CurrentRowCell="");1;2)

And apply this formula to each row by dragging it down.

Thus you’ll have in row 1: =IF(OR(A1="red";A1="");1;2)
in row 2: =IF(OR(A2="red";A2="");1;2)
in row 3: =IF(OR(A3="red";A3="");1;2)
etc...

-- 
Always keep in mind to accept a post that gets you out of trouble

raveno39 · Answer

ok it works thank you

Logic test with 2 conditions

5 answers

Asus vivobook pc won’t boot anymore, need help

Unlock a phone’ j

Username and password

Copy/paste scanned text jpeg format

Forum display in excel

Retrieve deleted texts

Edit ad on leboncoin for free

Convert text to audio

My amazon chat is stuck

Reinstallation of w11 impossible after pc crash...