Cost Per Page Countif formulea
Closed
RobDazey
Rob - Jul 17, 2009 at 07:06 AM
- Posts
- 1
- Registration date
- Wednesday July 15, 2009
- Status
- Member
- Last seen
- July 16, 2009
Rob - Jul 17, 2009 at 07:06 AM
Related:
- Cost Per Page Countif formulea
- M1x cost - Guide
- T mobile sim card replacement cost - Guide
- 3d tv cost - Guide
- Ps4 online cost - Guide
- How much does poppy playtime cost - Download
1 reply
venkat1926
Jul 16, 2009 at 09:56 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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