Welcome Guest.

7Answers

How to do multiplication in EXCEL, how can I not come out, how can I come out is D8*F8

Asked by: Scott Lee 300 views Software January 16, 2019

How to do multiplication in EXCEL, how can I not come out, how can I come out is D8*F8

7 Answers

  1. +5Votes  

    (1) Error 1::F8 cell number format is text

    (2) Error 2: E8 cell should be a number, not an expression

    Workaround:

    1) E8 cell plus equal sign or enter its score directly

    2 Use the macro table function – EVALUATE

    3) Convert the Lotus 1-2 with the clipboard function

    4) -3 formula

    Answer: Correction: “Score” should be changed to “Product”.

    Anthony Williams- January 16, 2019 |

  2. +8Votes  

    "D8"Setting to a value “E8” formula before entering “=”

    Jerry White- January 16, 2019 |

  3. +8Votes  

    Set the format of the cell to a numeric value or regular Yes

    Phillips- January 17, 2019 |

  4. +5Votes  

    You have a wrong multiplication expression. In a cell, its expression is:=D8*F8, your expression lacks the equal sign “=”

    Amanda Moore- January 17, 2019 |

  5. +4Votes  

    This is the formula to be entered. Add a “=” before D8*F8.

    Jose Wood- January 17, 2019 |

  6. +8Votes  

    Set the format of the cell below. Set to regular.

    Maria Wilson- January 17, 2019 |

  7. +7Votes  

    That’s because you set the cell to text format

       Right-click on the cell — Set cell format — number — select “General”   Just fine

    Stephen Adams- January 17, 2019 |