Forum Discussion

yvetteinhouston's avatar
yvetteinhouston
Copper Contributor
Jan 23, 2018

Re: Fields do not display data correctly

I hope that someone will be able to help me with these issues. I have a spreadsheet setup as: Equipment = dropdown to select equipment Formula = None B31 Quantity = user entry Formula = Non...
Excel
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    Jan 23, 2018

    Hello,

     

    try this in F31 and copy down:

     

    =IF(ISNUMBER(D31),PRODUCT(E31,D31),"")

     

    cheers, teylyn

IngeborgHawighorst's avatar
IngeborgHawighorst
MVP

Hello,

 

try this in F31 and copy down:

 

=IF(ISNUMBER(D31),PRODUCT(E31,D31),"")

 

cheers, teylyn

yvetteinhouston's avatar
yvetteinhouston
Copper Contributor
Jan 24, 2018

Thank you Teylyn very much, it works.

  • yvetteinhouston's avatar
    yvetteinhouston
    Copper Contributor
    Jan 24, 2018

    Is there a way to make sure that the text populates in Quantity field:D3?

     

    Thanks again in advance,

    Yvette

    • IngeborgHawighorst's avatar
      IngeborgHawighorst
      MVP
      Jan 25, 2018

      I'm not sure I understand the question. Can you explain?

      yvetteinhouston wrote:

      Is there a way to make sure that the text populates in Quantity field:D3?

       

      Thanks again in advance,

      Yvette

       

Resources