Scribd
Upload
2 views1 page

Excel Accounting Logical Formulas

Uploaded by

Hari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
2 views1 page

Excel Accounting Logical Formulas

Uploaded by

Hari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Category Formula Description Example

Logical IF(conditioConditionalHigh
Logical IFERROR(val Handle errError
Logical IFS(conditioMultiple co #NAME?
Logical AND(conditAll TRUE Check
Logical OR(conditiAny TRUE OK
AccountingABS(numbeAbsolute d #VALUE!
AccountingROUND(num Round deci #VALUE!
AccountingSUMIF(rangSum by con 0
AccountingSUMIFS(sum_ Sum with m 0
AccountingCOUNTIF(ran Count by c 0
Tax & LookVLOOKUP(va Vertical lo #NAME?
Tax & LookXLOOKUP(lo Flexible lo #NAME?
Tax & LookMATCH(look Find positi #N/A
Tax & LookINDEX(arraReturn val Error
Date & TimTODAY() Current da 08/28/25
Date & TimEDATE(starAdd month #VALUE!
Date & TimEOMONTH(s End of mon #VALUE!
Date & TimDATEDIF(sta Date diffe #VALUE!
Date & TimNETWORKDA Business d #VALUE!
Text CONCAT(text Join values #NAME?
Text LEFT(text, Left extracLogic
Text RIGHT(textRight extracal
Text MID(text, Middle extgica
Text TEXT(valueFormat valuLogical
Finance NPV(rate, vNet Presen 0
Finance IRR(values)Internal Ra Err:523
Finance FV(rate, npFuture Val 15917.13

You might also like