isavanande
New Member
- Joined
- Apr 7, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
- MacOS
- Web
Hi, I'm having trouble and need some help.
I have a Redemption column in google sheet with coupon codes and redemption %, I want my pivot table to calculate the redemption amount (Redemption%*Coupon_Value) only for the % values from 0-100%. I'm using the code =IF(Redemption<=100%,Redemption*Coupon_Value) & I also tried =IF(Redemption<=100,Redemption*Coupon_Value). I only get zeros where I should see the redemption amount. Did I overlook something?
I have a Redemption column in google sheet with coupon codes and redemption %, I want my pivot table to calculate the redemption amount (Redemption%*Coupon_Value) only for the % values from 0-100%. I'm using the code =IF(Redemption<=100%,Redemption*Coupon_Value) & I also tried =IF(Redemption<=100,Redemption*Coupon_Value). I only get zeros where I should see the redemption amount. Did I overlook something?