Previous Topic Next Topic

Formula geek help please!

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.

Help Please

Thanks

2 replies

Answer 1 / 2
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 )
0
Answer 2 / 2
rue
Jun 7, 2010 at 10:17 AM
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
0
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.
0
rue
Jun 7, 2010 at 10:52 AM
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.
0
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.
0