Excel formula
This query is : Resolved
19 June 2013
please let me know what is the function of doller ($) sign in excel formula ?
please guide
please guide
19 June 2013
if u want to keep $ as currency, then change it from format cell -> currency.
If you want to put $ to keep cell value constant use shift + 4 or f4.
If you want to put $ to keep cell value constant use shift + 4 or f4.
19 June 2013
suppose c4*E4 = result
but $c4*$E4 = same result
my question is why we use $ in formula
but $c4*$E4 = same result
my question is why we use $ in formula
19 June 2013
1)$E1 tells Excel you always want to refer to column E.
2)E$1 tells Excel you always want to refer to row 1.
3)$E$1 tells Excel you always want to refer to cell E1.
for you 1st instance applicable may be your requirement is you always want to refer coloumn E.
Thanks & regards
Ganesh babu k
2)E$1 tells Excel you always want to refer to row 1.
3)$E$1 tells Excel you always want to refer to cell E1.
for you 1st instance applicable may be your requirement is you always want to refer coloumn E.
Thanks & regards
Ganesh babu k
19 June 2013
Know some thing about dollor sign?why to use?
1)The absolute sign($), is used specially when you write an equation or any other thing in excel, and you want to copy it into other cells.
2)If you write "=E3+F3" in a cell, that cell will show the addition of E3 and F3. If you copy and paste to the cell below that, the equation will automatically change into "=E4+F4", also, if you copy that into the cell to the right of the first one, equation will change into "=F3+G3".
3)The absolute sign ($), avoids that, if you right that before the row or column (e.g. F$3 or $F3 or $F$3) the row, or column, or both, won't change when you copy and paste the equation.
Note: refer rules 1,2,3, as i said iin previous reply for ur reference
Note: it will be great help in sumif,vlookup,and many function while dong reconciliaiton and caluculations to give true results
Thanks & regards
Gaanesh babu k
1)The absolute sign($), is used specially when you write an equation or any other thing in excel, and you want to copy it into other cells.
2)If you write "=E3+F3" in a cell, that cell will show the addition of E3 and F3. If you copy and paste to the cell below that, the equation will automatically change into "=E4+F4", also, if you copy that into the cell to the right of the first one, equation will change into "=F3+G3".
3)The absolute sign ($), avoids that, if you right that before the row or column (e.g. F$3 or $F3 or $F$3) the row, or column, or both, won't change when you copy and paste the equation.
Note: refer rules 1,2,3, as i said iin previous reply for ur reference
Note: it will be great help in sumif,vlookup,and many function while dong reconciliaiton and caluculations to give true results
Thanks & regards
Gaanesh babu k
19 June 2013
1)I have got a vedio tutorial for you ..you can understand its use by this very clearly
http://www.youtube.com/watch?v=cBcDnHu9zQw
2)do u like to download vedios from you tube and want to know more about youtube channel which will be great help to us..
Please refer
https://www.caclubindia.com/forum/icai-bangalore-helps-very-much-238249.asp#.UUlffBwZ114
Thanks & regards
Ganesh babu k
http://www.youtube.com/watch?v=cBcDnHu9zQw
2)do u like to download vedios from you tube and want to know more about youtube channel which will be great help to us..
Please refer
https://www.caclubindia.com/forum/icai-bangalore-helps-very-much-238249.asp#.UUlffBwZ114
Thanks & regards
Ganesh babu k
Message likes :
1 times
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- ITC temporary reversal and reclaim
- GST on export of services and Input Credit
- Applicable TDS rate for sale of property in Nov 2024
- Inventory of finished goods
- GST ON EXPORT COMMISSION
- RCM INVOICING FROM NOV-2024
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- ITC EXCESS CLAIM + RCM NOT PAID...BOTH FOR FY 2020-21......PAID IN FY 2024-25....EFFECT
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding einvoice taken on nil rated sales
Trending Online Classes
CAclubindia
