Re: Add extra function to formula
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Try this:
=IF(AND(E3="ZEMO",M3="ZM"),U3,0)
Will only return U3 if both E3 and M3 contain the specified values.
Hope this helps.
Pete
On Jan 14, 11:47 am, enquirer2 <si...@xxxxxxxxxxxxxxxxxx> wrote:
=IF(E3="ZEMO",U3,0)
I need to add reference to a value in another cell also and cannot
find how to do this.
The above looks at cell E3 and if it contains ZEMO returns the value
of cell U3. I wish to modify the above formula to only show U3 value
if cell M3="ZM" If it doesn't then 0 is shown in U3.
Can anybody help?
.
Relevant Pages
- Re: Combining Text based on Values
... keeping column A as reference to names. ... Function concatAs String ... Dim cell As Range ... For Each cell In CellBlock ...
(microsoft.public.excel.programming) - RE: Lookup Data in two seperate Spreadsheets
... 'Cell Formula using the OFFSET worksheet formula with multiple criteria to ... Just as VLOOKUP will give you the FIRST value it finds that meets it's ... 'Returns a reference to a range that is a specified number of rows and columns ...
(microsoft.public.excel.worksheet.functions) - Re: Getting cell index from cell to the right
... Once per reference is sufficient, and can shorten your formula a little. ... Take Care RagDyer, ... Please keep all correspondence within the NewsGroup, ... I gave the cell a name and set it to refer to the cell to the ...
(microsoft.public.excel.misc) - RE: Lookup Data in two seperate Spreadsheets
... 'Cell Formula using the OFFSET worksheet formula with multiple criteria to ... Just as VLOOKUP will give you the FIRST value it finds that meets it's ... 'Returns a reference to a range that is a specified number of rows and columns ...
(microsoft.public.excel.worksheet.functions) - RE: Lookup Data in two seperate Spreadsheets
... 'Cell Formula using the OFFSET worksheet formula with multiple criteria to ... Just as VLOOKUP will give you the FIRST value it finds that meets it's ... 'Returns a reference to a range that is a specified number of rows and columns ...
(microsoft.public.excel.worksheet.functions) |
|
