Forum Discussion
Solved
Formula help please
Hello everyone ! For my work, i would like to create a rule for a database. It’s for Internship agreement. I have 4 important columns: A. for the sector B. to indicate whether the internshi...
Starting point could be
=IF((A1=”1st year of psychology”)*(B1=”Yes”), IF(C1<120,”Lack of hours”, "Lot of hours"), "Other options")
Starting point could be
=IF((A1=”1st year of psychology”)*(B1=”Yes”), IF(C1<120,”Lack of hours”, "Lot of hours"), "Other options")
SergeiBaklan Thanks, it works. Can I do this for the whole sheet with different values for A and C ?
Yes, sure. If above formula is in D1 just drag the cell down till end of you range.
And better to keep your criteria texts not within the formula but in another cells. Let say ”1st year of psychology” is in cell H1, when the formula will be like
=IF((A1=$H$1)*(B1=....
