Can anyone please tell me why in Cell F13 the answe should be 1 but is coming up as 2.
It seems to work OK in Cell G13, H13, I13 and J13.
Any ideas will be appreciated.
Regards
Can anyone please tell me why in Cell F13 the answe should be 1 but is coming up as 2.
It seems to work OK in Cell G13, H13, I13 and J13.
Any ideas will be appreciated.
Regards
Your formula =IF(P10,ROUNDDOWN(F10,0),"") suggests roundingdown Column 'F' (not P) hence the answer is 2.
You could change it to =IF(P10,MIN(ROUNDDOWN(F10,0),ROUNDDOWN(P10,0)),"")
Life's a spreadsheet, Excel!
Say thanks, Click *
I'm not clear as to what you are trying to do, but try this ...
In F13
OrPlease Login or Register to view this content.
Drag/Fill Across to Column J.Please Login or Register to view this content.
Last edited by Marcol; 07-09-2012 at 04:42 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Excel-Access,
Did any of these work for you? If they did, kindly mark the thread as solved. Any feedback too, is always appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks