ElaKiri Community
Downloads
Go Back   ElaKiri Community > General > ElaKiri Help
Reload this Page Excel Formula
Reply
 
Thread Tools
(#1)
Old
ctpgamage ctpgamage is offline
Senior Member
ctpgamage has a spectacular aura aboutctpgamage has a spectacular aura aboutctpgamage has a spectacular aura aboutctpgamage has a spectacular aura about
 
Posts: 2,254
Join Date: Jul 2009
laugh Excel Formula - 07-03-2019, 11:37 AM

machanla column dekaka menna me vidiyata tiyena values wala mama dala tiyena vidiya answer eka ganna formula eka ganna vidiya kiyannako...


-2.00 4.313 answer eka 6.313


-4.00 -2.500 answer eka 1.500


answer eka + value ekak enna ona
Reply With Quote
(#2)
Old
wqe123 wqe123 is offline
Senior Member
wqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to behold
 
Posts: 2,993
Join Date: Aug 2015
Location: ලංකාවේ.. ලංකාවේ
07-03-2019, 12:01 PM

Quote:
Originally Posted by ctpgamage View Post
machanla column dekaka menna me vidiyata tiyena values wala mama dala tiyena vidiya answer eka ganna formula eka ganna vidiya kiyannako...

-2.00 4.313 answer eka 6.313
-4.00 -2.500 answer eka 1.500

answer eka + value ekak enna ona


Option 1



assume -2 in A, 4.413 in B, 6.313 in C

in D Column =IF(C5>=0.0001,C5,(C5*-1))


Option 2

assume -2 in A, 4.413 in B, 6.313 in C
in C Column New Formula

=IF(A1<=0.001,((A1-B1)*-1),(A1-B1))

Last edited by wqe123; 07-03-2019 at 12:07 PM.
Reply With Quote
(#3)
Old
Lejayange's Avatar
Lejayange Lejayange is offline
Senior Member
Lejayange has much to be proud ofLejayange has much to be proud ofLejayange has much to be proud ofLejayange has much to be proud ofLejayange has much to be proud ofLejayange has much to be proud ofLejayange has much to be proud ofLejayange has much to be proud ofLejayange has much to be proud ofLejayange has much to be proud ofLejayange has much to be proud of
 
Posts: 16,807
Join Date: Mar 2015
07-03-2019, 12:06 PM

Quote:
Originally Posted by wqe123 View Post
assume -2 in A, 4.413 in B, 6.313 in C

in D Column =IF(C5>=0.0001,C5,(C5*-1))

එක සෙල් එකක ඉලක්කමෙන් ලියපු සංඛ්‍යාවක් වෙන සෙල් එකක වචනෙන් එන විදියට හදාගන්නෙ කොහොමද...?
Reply With Quote
(#4)
Old
wqe123 wqe123 is offline
Senior Member
wqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to behold
 
Posts: 2,993
Join Date: Aug 2015
Location: ලංකාවේ.. ලංකාවේ
07-03-2019, 12:10 PM

Quote:
Originally Posted by Lejayange View Post

එක සෙල් එකක ඉලක්කමෙන් ලියපු සංඛ්‍යාවක් වෙන සෙල් එකක වචනෙන් එන විදියට හදාගන්නෙ කොහොමද...?

උබට ඕනේ චෙක් ප්‍රින්ට් එකක් වගේ දෙයකදී ඉල්ලනකමෙන් ලියපු එක අකුරින් ලියන්න නේ

සරලව කරන්න බෑ. එක්කෝ මැක්‍රෝ ( VB ) එකක් ලියන්න වෙනවා
එහෙම නැති නම් VB වලින් හදපු add-on එකක් ඉන්ස්ටල් කරන්න වෙනවා
පහල ලින්ක් එක බලන්න

https://support.office.com/en-us/art...8-69442cd55d98


.

Last edited by wqe123; 07-03-2019 at 12:35 PM.
Reply With Quote
(#5)
Old
ruchira55's Avatar
ruchira55 ruchira55 is offline
Senior Member
ruchira55 is a splendid one to beholdruchira55 is a splendid one to beholdruchira55 is a splendid one to beholdruchira55 is a splendid one to beholdruchira55 is a splendid one to beholdruchira55 is a splendid one to beholdruchira55 is a splendid one to beholdruchira55 is a splendid one to beholdruchira55 is a splendid one to beholdruchira55 is a splendid one to beholdruchira55 is a splendid one to behold
 
Posts: 23,364
Join Date: Mar 2012
07-03-2019, 12:21 PM

Quote:
Originally Posted by Lejayange View Post

එක සෙල් එකක ඉලක්කමෙන් ලියපු සංඛ්‍යාවක් වෙන සෙල් එකක වචනෙන් එන විදියට හදාගන්නෙ කොහොමද...?
Module ekak thiyenawa. Google eke balapan
Reply With Quote
(#6)
Old
imhotep imhotep is online now
Senior Member
imhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to all
 
Posts: 3,570
Join Date: Mar 2017
07-03-2019, 12:33 PM

Quote:
Originally Posted by Lejayange View Post

එක සෙල් එකක ඉලක්කමෙන් ලියපු සංඛ්‍යාවක් වෙන සෙල් එකක වචනෙන් එන විදියට හදාගන්නෙ කොහොමද...?
https://support.office.com/en-us/art...8-69442cd55d98

Check the above link... make adjustments to change to Rs & cents
Reply With Quote
(#7)
Old
ctpgamage ctpgamage is offline
Senior Member
ctpgamage has a spectacular aura aboutctpgamage has a spectacular aura aboutctpgamage has a spectacular aura aboutctpgamage has a spectacular aura about
 
Posts: 2,254
Join Date: Jul 2009
07-03-2019, 12:50 PM

Quote:
Originally Posted by wqe123 View Post
Option 1



assume -2 in A, 4.413 in B, 6.313 in C

in D Column =IF(C5>=0.0001,C5,(C5*-1))


Option 2

assume -2 in A, 4.413 in B, 6.313 in C
in C Column New Formula

=IF(A1<=0.001,((A1-B1)*-1),(A1-B1))



column C eke thiyena answer eka tamai ganna ona
Reply With Quote
(#8)
Old
Naughtykolla48's Avatar
Naughtykolla48 Naughtykolla48 is offline
Senior Member
Naughtykolla48 is a splendid one to beholdNaughtykolla48 is a splendid one to beholdNaughtykolla48 is a splendid one to beholdNaughtykolla48 is a splendid one to beholdNaughtykolla48 is a splendid one to beholdNaughtykolla48 is a splendid one to beholdNaughtykolla48 is a splendid one to beholdNaughtykolla48 is a splendid one to beholdNaughtykolla48 is a splendid one to beholdNaughtykolla48 is a splendid one to beholdNaughtykolla48 is a splendid one to behold
 
Posts: 5,193
Join Date: Nov 2017
Location: හඳට කිට්ටුව
07-03-2019, 12:54 PM

patta, tfs
Reply With Quote
(#9)
Old
wqe123 wqe123 is offline
Senior Member
wqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to beholdwqe123 is a splendid one to behold
 
Posts: 2,993
Join Date: Aug 2015
Location: ලංකාවේ.. ලංකාවේ
07-03-2019, 02:00 PM

Quote:
Originally Posted by ctpgamage View Post
column C eke thiyena answer eka tamai ganna ona

ayyo ban, C eke ekaparama formula eka daana krame thama option 2 wala thiyernne.
Option 1 wala thiyenne uba hadagaththa uththare minus eka ayin karana widiha.


moka kalath dekema thiyenne ekama de. ekaka akulala, anike diga arala...
Reply With Quote
(#10)
Old
ACHIK's Avatar
ACHIK ACHIK is offline
Senior Member
ACHIK is a name known to allACHIK is a name known to allACHIK is a name known to allACHIK is a name known to allACHIK is a name known to allACHIK is a name known to allACHIK is a name known to allACHIK is a name known to allACHIK is a name known to allACHIK is a name known to allACHIK is a name known to all
 
Posts: 8,934
Join Date: Jun 2015
07-03-2019, 02:13 PM

Bump.
Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



Copyright © 2006 - 2011 ElaKiri™ Beta2.Evo vBulletin, vBa iBproArcade Subdreamer I-Magic MKv

Page generated in 0.02711 seconds with 11 queries