Easy Office
LCI Learning

Excel

This query is : Resolved 

Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
27 December 2012
Simple Formula

25
30
TOTAL =SUM(B4:B5) A

But I would Like To Known That If Some One Insert A fig In Formula then How To Known

Eg:
25
30
TOTAL =SUM(B11:B12)+6 B


IF U SEE B THEN AMT 6 HAS BEEN ADDED IN THE FORMULA
HOW TO KNOWN THAT 6 HAS BEEN ADDED IN FORMULA THAT IS =SUM(B11:B12)+6

IN A NUTSHELL ANY FORMULA IS THERE TO KNOWN THAT 6 HAS BEEN ADDED IN THE FORMULA
BECAUSE THIS IS ONLY A SINGLE FORMULA BUT I AM HAVING SHEET WHICH HAS MORE THAN
120 FORMULA SO A QUICK LOOK THAT A FIG HAS BEEN ADDED IN THE FORMULA
HOW TO KNOW ??????????????????

28 December 2012 Just press ctrl+` (i.e. the key below the esc button).



You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries




Answer Query