Hi All
This is second post of the day
If the business turnover (column A) is blank, and the channel is SE0 then populate column C with “321607.1”
If the channel is PPC then populate column C with 1175000, However if there is a business turnover for both SE0 and PPC then return the value in column A
Would appreciate any help Available
Not sure..maybe try
=IFERROR(IF(AND(A2="",B2="SE0"),321607.1,IF(B2="PPC",1175000,A2)),"")
Else, what are your expecetd results?
Life's a spreadsheet, Excel!
Say thanks, Click *
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi Ace_Xl
Thank you for your swift response
I think your formula will work i just need it tweaked a little.
How can i edit your formula to say if (column A) is blank and its not either SE0 Or PPC then produce a zero ?
Try
=IFERROR(IF(AND(A2="",B2="SE0"),321607.1,IF(B2="PPC",1175000,A2)),0)
Ace_Xl
You are a gem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks