can this if functiom work ?

Occasional Contributor

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



4 Replies


What exactly is your question?

@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.

best response confirmed by Grahmfs13 (Microsoft)


Yes, it should work on much larger tables too.