if condition help

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › if condition help

Viewing 2 reply threads
  • Author
    Posts
  • February 14, 2017 at 11:11 PM #21121

    Andrew Mead
    Participant

    Hi Brendan,

    Can you please tell me why this won’t work. It is designed to work out the amount of income tax to pay (in Aus) base on a value that is entered into a filed called ‘Test’ which is a number field.

    I am suspecting it maybe the AND condition but would appreciate your thoughts

    =IF(
    <=18200,0,IF(AND(
    >=18201,
    <=37000),(
    -18200)*0.19,IF(AND(
    >=37001,
    <=87000),3572+(
    -37000)*0.325,IF(AND(
    >=87000,
    <=180000),19822+(
    -87000)*0.37,IF(AND(
    >=180001),54232+(
    -180000)*0.45)))))

    February 15, 2017 at 2:46 PM #21124

    Andrew Mead
    Participant

    Hi

    Sorry I should have mentioned this formalua was copied out of Excel, where it is working fine

    Thanks

    Andrew

    February 15, 2017 at 5:45 PM #21128

    Brendan
    Keymaster

    Hi Andrew,

    Ya, I’m not sure what that AND is doing in there. It’s not supported in Tap Forms. All you got are these functions:

    https://www.tapforms.com/help-mac/5/en/topic/calculations

  • Author
    Posts
Viewing 2 reply threads

You must be logged in to reply to this topic.