Forum

Notifications
Clear all

If Function

2 Posts
2 Users
0 Reactions
72 Views
(@nehal-halai)
Posts: 1
New Member
Topic starter
 

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

 
Posted : 14/10/2020 3:08 am
(@questvba)
Posts: 125
Estimable Member
 

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.

 
Posted : 14/10/2020 5:42 am
Share: