Excel Forum

If Function

Nehal Halai

New Member

Members

Forum Posts: 1

Member Since:
October 13, 2020

Offline

October 13, 2020 - 5:08 pm

We only place an order when we have at least 3 items that need re-ordering. In K14 enter a calculation that returns Yes if there are 3 or more items that require reordering, and otherwise returns No. How do we do this in excel

Lionel Baijot

Member

Members

Forum Posts: 114

Member Since:
September 9, 2020

Offline

October 13, 2020 - 7:42 pm

Hi Nehal Halai,
This is a very good question but the solution may be different depending on your data, the structure of your file.
Could you attach a file with anonymised data?

BR,

Lionel.

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Dana Friedt, Brenda Richards, Shawn Barwick, Nada Perovic

Guest(s) 10

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:

terimeri dooriyan

Jack Aston

AndyC

Denise Lloyd

michael serna

mashal sana

Tiffany Kang

Leah Gillmore

Sopi Yuniarti

LAFONSO HERNANDEZ

Forum Stats:

Groups: 3

Forums: 24

Topics: 6218

Posts: 27265

Member Stats:

Guest Posters: 49

Members: 31901

Moderators: 3

Admins: 4

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

Moderators: MOTH Support, Velouria, Riny van Eekelen