SOLVED

can this if functiom work ?

Copper Contributor

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

mtlbooks_0-1673385559787.png

 

4 Replies

@mtlbooks 

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)
Solution

@mtlbooks 

Yes, it should work on much larger tables too.

thanks!
1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

@mtlbooks 

Yes, it should work on much larger tables too.

View solution in original post