Hi I'm new here. I hope I can explain my problem here it goes: What I'm trying to do is use; =IMDIV formula on a cell, this works perfectly and returns the right value; it is a number that shows on the cell. Then on another cell next to it I use another formula: =PRODUCT this is meant to use the number that appears in =IMDIV to multiply with the number of another cell and return the value (a positive number) that I'm looking for however, I keep just getting 0.0 . If I remove the formula =IMDIV and write the value that the formula would return, then the =PRODUCT cell returns the right value positive number. This may also help in my explanation: Cell G6 contains the following formula =IMDIV(G2,G1) Cell F6 contains the following formula =PRODUCT(G6,B6) but returns a 0.0 can you help me with this problem? Thank you so much I hope I'm not making *** of my self forgive me if I am.![]()
Bookmarks