Hi all
this is my formula
=IF(G2=1,A2,AGGREGATE(15,6,A$2:A$31/((B$2:B$31=B2)*(D$2:D$31=D2)*(E$2:E$31=E2)),1))
however, i have just realised that if the cells in the same row are blank it produces Jan-00 is there a way of changing it to stay blank?
Many thanks
Ashley
Do you mean that you want something adding to deal with G2 being blank? If so, try this:
=IF(G2="","",IF(G2=1,A2,AGGREGATE(15,6,A$2:A$31/((B$2:B$31=B2)*(D$2:D$31=D2)*(E$2:E$31=E2)),1)))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
brilliant! i was trying to make it happen after the initial IF. thanks Ali! works a treat!
No problem!
Hey Ali, any chance you can explain why i would get #VALUE error with this one, when M3 is blank? - there is a formula in M3
=IF(M3=" "," ",EDATE(M3,6))
Try this and tell me if it works:
=IF(M3="","",EDATE(M3,6))
No space between the speech marks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks