6 Replies Latest reply on Oct 8, 2018 7:27 AM by Jonathan Drummey

    If statement (can't mic aggregate and non aggregate comparison

    Tony Fahd

      Hi, I am attaching a workbook where I have two types of purchases (car and house). i am trying to create an if function where i like to sum the amount paid by a constant number. so if my year is 2017 I need to sum the amount and divide by 100 otherwise if my year is 2018 i want to sum amount and divide by 200. the function is not working. any help is appreciated.