Cost Per Page Countif formulea
Closed
RobDazey
Posts
1
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
July 16, 2009
-
Jul 16, 2009 at 10:18 AM
Rob - Jul 17, 2009 at 07:06 AM
Rob - Jul 17, 2009 at 07:06 AM
Related:
- Cost Per Page Countif formulea
- Does it cost money to change your number - Guide
- Linkedin learning cost - Guide
- Kick sub cost - Guide
- Netflix cost per month - Guide
- Opera gx cost - Download - Browsers
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 16, 2009 at 09:56 PM
Jul 16, 2009 at 09:56 PM
suppose the no of pages (120) is in A2
in B2 copy paste this formula (both lines if there are in two lines in your received message)
=IF(AND(A2>0,A2<=20),0.93*(A2-20),IF(AND(A2>20,A2<=100),0.93*20+0.83*(A2-100),IF(A2>100,0.93*20+0.83*80+0.66*(A2-100),"")))
in B2 copy paste this formula (both lines if there are in two lines in your received message)
=IF(AND(A2>0,A2<=20),0.93*(A2-20),IF(AND(A2>20,A2<=100),0.93*20+0.83*(A2-100),IF(A2>100,0.93*20+0.83*80+0.66*(A2-100),"")))
Jul 17, 2009 at 07:06 AM