Hi Guys
In the attached workbook in column K what I would like to do is have a formula that does the following -
If H2=YES then divide by2, if H2=NO then return the value in G2
Is that possible?
Thanks
Hi Guys
In the attached workbook in column K what I would like to do is have a formula that does the following -
If H2=YES then divide by2, if H2=NO then return the value in G2
Is that possible?
Thanks
It is possible, but what cell do you wish to divide by 2?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
You can use this formula in K2:
=IF(H2="YES",G2/2,G2)
then copy down.
Hope this helps.
Pete
Spot on, thanks Pete
Glad to help - thanks for marking the thread as Solved.
You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks