My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

if function with dependant |General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / if function with dependant |General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
if function with dependant
Avatar
khoro Avhavhoni Tshivhula

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
November 8, 2021
sp_UserOfflineSmall Offline
1
November 8, 2021 - 12:26 pm
sp_Permalink sp_Print

hello, I have this challenge. I don't know how to solve it.

if D2 equals 1, check if the date on E2 is older than the date on G1 and return "pay" if the date is younger "not pay" and if d2 is greater than 1 return pay

sp_AnswersTopicSeeAnswer See Answer
Avatar
Lionel Baijot
Member
Members
Level 0
Forum Posts: 116
Member Since:
September 9, 2020
sp_UserOfflineSmall Offline
2
November 8, 2021 - 8:53 pm
sp_Permalink sp_Print

Hi,

Here is a solution in your file.

BR,

Lionel

sp_AnswersTopicAnswer
Answers Post
Avatar
Mohana pattem

New Member
Members
Level 0
Forum Posts: 2
Member Since:
November 8, 2021
sp_UserOfflineSmall Offline
3
November 8, 2021 - 10:16 pm
sp_Permalink sp_Print sp_EditHistory

Thank you for your informaion

Avatar
khoro Avhavhoni Tshivhula

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
November 8, 2021
sp_UserOfflineSmall Offline
4
November 9, 2021 - 1:26 am
sp_Permalink sp_Print

thank you very much 

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Kumud Patel, Bright Asamoah
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Gilbert Lemek
Ashleigh Farquharson
Jayz Luu
Fred Smith
Charles DeGraffenreaid
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Forum Stats:
Groups: 3
Forums: 24
Topics: 6360
Posts: 27812

 

Member Stats:
Guest Posters: 49
Members: 32340
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen