Formula geek help please!
Closed
rue
-
Jun 7, 2010 at 09:50 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2010 at 10:55 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2010 at 10:55 AM
Related:
- Formula geek help please!
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 7, 2010 at 09:58 AM
Jun 7, 2010 at 09:58 AM
for C35
=IF(C31 - C29 <= 30000, C31 - C29, 30000)
for C34
=IF(C31 - C29 < =30000, "", C31 - C29 -30000 )
=IF(C31 - C29 <= 30000, C31 - C29, 30000)
for C34
=IF(C31 - C29 < =30000, "", C31 - C29 -30000 )
thanks for this. i have tried but still doesnt seem to work.
If sum of C31- SUM C29 Is greater than £30000.00 then the difference i.e C31-C29 needs to go into C34
and if the sum of c31-sum c29 is less than 3000.00 then the answer to c31-c9 needs to go into c35
I think. lol.
basically i am trying to work out taxable and non taxable.
C34 is taxable therefore is if C31 and C29 is greater than 30000.00
C35 is non taxable therefore if c31-c29 is less than 3000.00 then the figure needs to go in here
Thanks for all help
If sum of C31- SUM C29 Is greater than £30000.00 then the difference i.e C31-C29 needs to go into C34
and if the sum of c31-sum c29 is less than 3000.00 then the answer to c31-c9 needs to go into c35
I think. lol.
basically i am trying to work out taxable and non taxable.
C34 is taxable therefore is if C31 and C29 is greater than 30000.00
C35 is non taxable therefore if c31-c29 is less than 3000.00 then the figure needs to go in here
Thanks for all help
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 7, 2010 at 10:33 AM
Jun 7, 2010 at 10:33 AM
Could you please give example ?
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ ,https://accounts.google.com/ServiceLogin?passive=1209600&continue=https://docs.google.com/&followup=https://docs.google.com/&emr=1 http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ ,https://accounts.google.com/ServiceLogin?passive=1209600&continue=https://docs.google.com/&followup=https://docs.google.com/&emr=1 http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 7, 2010 at 10:55 AM
Jun 7, 2010 at 10:55 AM
Now you were clear in that. But you said the formula does not work I think it should work.So if i see solid numbers i can see where i am misleading you.
