can this if functiom work ?

[mtlbooks]

here is the link to the shet on one drive:ExpenseReport1.xlsx

[#2]

@mtlbooks 

What exactly is your question?

[#3]

@Hans Vogelaar 

I see that it's working on this sheet, but I want to use it on a bigger sheet , and I just want to make sure that the IF function is meant to be used like that, to prevent miscalculations that I won't recognize.

[#4 · Accepted solution]

@mtlbooks 

Yes, it should work on much larger tables too.

[#5]

thanks!