Most RecentMost ViewedMost LikesSelection from the word doc and auto generate / with auto function feature to PDF file Hi all, is there a way to tick the box from word doc / kind of selection / choice and then based on the choice it will auto generate / with auto function feature to generate the document into PDF file? Subtracting from the addition of 2 specific cells with a given condition / given conditions. Hello. I was messing around in Excel and I want to subtract from the addition of one specific cell to another, only if the product is larger than a given criteria. So e.g. B1=1500 , C8 = 5692 , condition = ">6400" So if possible, I would want to write something like =SUMIF((B1+C8),">6400",-6400) or something like that. I have 3 main problems: 1. The SUMIF function apparently only works for ranges of data, not specific cells. In this case, I only need 2 specific cells, i.e. B1 and C8. Am I using the wrong function then? 2. I don't know how to include the -6400 part if the conditions are met. How do I do that? 3. In the future, if let's say I would like to add more conditions, how do I introduce more conditions? Is it even possible in the first place? If someone can kindly advise me, I would appreciate it very much, thank you... Solved
