View original (French)

How to integrate an IF function in a calculated field

vg42 -  
 vera -
Hello,

So here is my situation, I have a column "order amount" and I would like to create a calculated field in my pivot table that displays the number of rows where the order amount is <150.

Thank you for your help.

Configuration: Windows / Firefox 68.0

2 réponses

Réponse 1 / 2
vera
 
=IF(A2<150,1,0)

You need to put this formula in an empty column.
This will give you a column with 0s and 1s.
Just sum this column.

I hope that’s clear enough

V
0