Excel Forum

(If) Function

Amel Al Faris

Active Member

Members

Forum Posts: 3

Member Since:
May 21, 2020

Offline

May 22, 2020 - 12:42 am

I would like to make (If function)

= IF(N5="Alinity hq I (173)",Amel Al Faris, IF(N5=" Alinity hq II (198)",Amel Al Faris,, IF(N5=" Sysmex 2500",Moneer,))).

but it is not correct.

Regards

Philip Treacy

Admin

Forum Posts: 1514

Member Since:
October 5, 2010

Offline

May 22, 2020 - 9:08 am

Hi Amel,

Try this

= IF(N5="Alinity hq I (173)","Amel Al Faris", IF(N5="Alinity hq II (198)","Amel Al Faris", IF(N5="Sysmex 2500","Moneer")))

When specifying a text string as a result you need to wrap it in quotes i.e. "Amel Al Faris"

Also, as it is that formula will work but it does not specify a result if the final IF is false. So IF(N5="Sysmex 2500","Moneer") does not have a value for a False result meaning IF will actually return the Boolean value False.

These links may help you

IF Function Explained

IF Formula Builder

Please see attached file for working formula.

regards

Phil

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Ruth Savage, Andy Kirby, Roy Lutke, Jeff Krueger, Tom VAN LOO

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

John Chisholm

vexokeb sdfg

John Jack

Malcolm Toy

Ray-Yu Yang

George Shihadeh

Naomi Rumble

Uwe von Gostomski

Jonathan Jones

drsven

Forum Stats:

Groups: 3

Forums: 24

Topics: 6212

Posts: 27236

Member Stats:

Guest Posters: 49

Members: 31889

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen