Search:

Type: Posts; User: Bob Phillips; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    428

    Just use =A1*A2 with a custom format of...

    Just use

    =A1*A2

    with a custom format of $#,##0.00"ea"
  2. Use this formula in TeacherView ...

    Use this formula in TeacherView

    =IF(ISNA(MATCH($A3,'Class view'!B$2:B$11,0)),"",INDEX('Class view'!$A$2:$A$11,MATCH($A3,'Class view'!B$2:B$11,0)))
  3. Shouldn't you refer to a single cell, not the...

    Shouldn't you refer to a single cell, not the whole column

    =VLOOKUP(OFFSET(F2,0,-2),'Lookup current policies.xlsx'!ExpiryDates,2,0)
  4. Replies
    2
    Views
    570

    You can't divide a cell or pair of cells...

    You can't divide a cell or pair of cells diagonally, but you could overlay a triangular shape with a high transparency factor. But I have to ask what is your objective. Having a value in one of the...
  5. Replies
    20
    Views
    1,359

    The real requirements are slowly seeping out, I...

    The real requirements are slowly seeping out, I bet we haven't got them all yet.

    Try this

    =IF(AND(D3=H3,ISNUMBER(MATCH(E3,$I3:$O3,0))),INDEX($I$2:$O$2,1,MATCH(E3,$I3:$O3,0)),"")
  6. Replies
    20
    Views
    1,359

    Try this array formula ...

    Try this array formula

    =IF(ISERROR(MATCH(D3,$H$3:$H$7,0)),"",MIN(IF($I3:$O3<>"",$I$2:$O$2)))
  7. Replies
    20
    Views
    1,359

    That is what my formula does.

    That is what my formula does.
  8. Replies
    20
    Views
    1,359

    Try =INDEX($I$2:$O$2,MATCH($E3,$I3:$O3,0))

    Try

    =INDEX($I$2:$O$2,MATCH($E3,$I3:$O3,0))
Results 1 to 8 of 8