True or False Value based on 3 difference cells' criteria

Solved/Closed

KEVB - Jul 26, 2017 at 03:38 PM
Blocked Profile - Jul 26, 2017 at 04:49 PM

Hello,

I need a True or False (or Y/N) return if for example:

A1>=30 AND B1>=80 AND C1>=80

but I have been unable to get IFS to work with three different cells and criteria

True or false : if the system shows an error message: "no timer tick interrupt" it could be a faulty motherboard.
Voice message downloader - Guide
Network error occurred - Guide
Insert a tick in word - Guide
Cmos checksum error - Guide
Post error the system time is invalid ✓ - CPU & Desktop Forum

1 response

Answer 1 / 1

Blocked Profile
Jul 26, 2017 at 04:49 PM

The If syntax is as follows:
=IF(logicTest,True,False)

You can nets IF statments as in:
=IF(logicTest,True,if(Logictest2,truth2,false))

I hope this helps you out!

Similar discussions

Corel Draw: Error Reading file problem

cannot save attachment for yahoo email

testingcheatsenabled true wont work for sims3

Removing write protection using Diskpart

Why Sims 3 testingcheatsenabled true won't work.

Similar discussions

Subscribe To Our Newsletter!