Here are some problems that our users have asked and received explanations on
sir, how to find age calculator age on date formula
Solved by A. A. in 22 mins
I have created a formula with true and false however would like it to be $0 if the cells are blank.
=IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)
Solved by O. E. in 12 mins
I'm merging two databases and need to remove or flag rows from Database 2 if the column (email domain) is present in Database 1.
Solved by T. H. in 14 mins
I need to analyse data and not always return the 1st instance of a lookup.
Eg. I have an account number, ID number and a domain name
There are instances where the same account and ID numbers on a row have a different domain name.
My use so far always defaults to give me the 1st instance of that combination, but I need to return all domain names, either in one cell or separate cells
Is this possible ?
Solved by Z. L. in 19 mins
I have a calculator that customers can use. They enter their name and company details first so we can identify them. Then they enter a series of numbers into the calculator to generate an answer. How do I prevent the calculator returning an answer (and return a suitable message) if the initial name/company fields are left blank?