SOLVED
Home

Formula help please

L_b23
New Contributor

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 internship is mandatory or not

C. for the total duration of the internship.

D. For remarks.

 

I’d like a rule like that:

When A=”1st year of psychology” and B=”Yes”, if C<120h so D=”Lack of hours”

Is it possible?

 

Thanks

Lorelen

3 Replies
Solution

Starting point could be

=IF((A1=”1st year of psychology”)*(B1=”Yes”), IF(C1<120,”Lack of hours”, "Lot of hours"), "Other options")

 

Highlighted

@Sergei Baklan 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=....
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies