Closed
rue - Jun 7, 2010 at 09:50 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 7, 2010 at 10:55 AM
Hello,

I am trying to get the following:

If the sum of C31- Sum C29 is less than £30000.00 then enter the figure in C35

If the sum on c31- sum c29 is greater than 3000.00 then the figure of 30000.00 goes in C35 and the amount above £30000.00 in C34.

Thanks

## 2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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 )
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
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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.
if value of C31+C29 is greater than or equal to £30000.00 then enter the c31-c29 in Field C34

if value of c31+c29 is less than £30000.00 then enter the value of C31-C29 IN field C35.

mayeb the above now makes sense.
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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.