IF calculation


MB Group

I am writing a sheet for my tax return. I am writing the
distance in one cell. In the second I need to deduct 12 KM
for each day, per direction. Third cell needs to return
the value above 100 KM each day. If this sum is lees than
100 KM the formula just has to leave the value "as is".
And is there, by the way, a possibility to include the
value 1,59 per KM < 100 and 0,79 > 100 per KM in the
formula. I can make the first part of the funtion to
return the value > 100 as a result, but how do I get the
formula to leave the figure entered. As I often work from
one day into another one formula needs to be able to only
deduct the 12 KM per direction once a day.

Who can help me on this one?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculations 6
Calculation 0
Calculations 1
Payment calculator 1
No value calculated 2
calculate error 1
Time calculations 1
Calculations not updating 0