I am trying to make a formula with following logic.
statement . I have attached excel sheet for further explanation.
if cell E3 is equal to "Desk" and cell d2 is equal to "buy" then cell I3 shoul show result of (F3+H2) OR if cell E3= "desk" and cell D2 is equal to "Sell" then Cell I3 should show result as (F2-H2)
Are you still using Excel 2003?
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I think ...
In H3 copied down:
=IF(AND(E3="DESK",D3="Buy"),F3+H2,H2)
In I3 copied down:
=IF(AND(E3="DESK",D3="Sell"),F3-H2,I2)
Formula:
Please Login or Register to view this content.
Last edited by JohnTopley; 08-29-2023 at 02:13 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on at least TWO other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
Last edited by AliGW; 08-29-2023 at 03:41 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks