View Single Post
  #1   Report Post  
Wilbur Chua Wilbur Chua is offline
Member
 
Posts: 47
Default Ifs!

Hello, For multiple conditioned IF function, it would be best to use the IFS Function in excel.

IFS function work the same as the IF function, but:

=ifs(Logical test 1, value if true1, logical test 2, value if true 2...)

this can hold more conditions that your usual if function. it also makes things easier to type and look at. Hope this helps!