multiple formulas in one cell and currency
hello! i am havinf trouble with this formula(s). i made a short (and bad, lol) video og my problem, hope someone can take a look and tell me what the problem is!! for some reason i cant post a link to the video, but please go to youtube and search "EXCEL TROUBLE. PLEASE HELP." and find the video posted by "Andreas Måsøval"
Welcome to the forum!
We don’t go hunting on YouTube to understand someone’s issues - sorry. You must explain them here. You can attach a workbook.
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.
Im trying to use multiple formulas in the same cell, and I want it to put out in curency, but for some reason it puts the result out in some wierd numbers when I have more than one formula. in the start of the video it is shown like i want it to be, and in the end it is shown wierd. hope you understand what i mean.Originally Posted by AliGW
The formula is =if(E9=«AUGUST»;Q3:0) <—— this formula works and it outs out in curency
When i try to add =if(E9=«AUGUST»;Q3:0)&if(E9=«JULY»;Q4;0) <—— this formula kinda works, but it puts out to result like «012345.000» instead of «$ 12345.00» like i want it to.
In the cell of E9 there is a dropdown list of the different months
Hope someone understand what i Mean.
The second formula is a concatenation - if you want a sum, use + instead if &.
Sorry, but as I said, we are not going to go hunting for the video.
As I also suggested, attach the workbook here.
Okay yeah i changed it to + instead og & now and ot worked!! Thank you very much!😁
You’re welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks