Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
DD
DD asked in Computers & InternetSoftware · 1 decade ago

Ms Excel Formula tips (Not VBA)?

how do i insert a value in a cell from another cell

cell A1=if(sum(A5:A12)>25,F12="Good Result", F12="Bad")

the calculation will be displayed in cell A1 and cell F12 the result. I dont want cell F12 to contain any formula but just the result of the calculation in A1. is it posible?

p/s: i dont want to use VBA though its easier.

4 Answers

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    Excel functions must be enterred before it is calculated

    The only way to do it without VBA is may be using scinarios, did you tried it?

    I am sure can help you

    I am after all the VBAXLMan here

    mail me to show you how, it can not be shown here

    VBAXLMan

  • IXL@XL
    Lv 7
    1 decade ago

    Cell A1 type =SUM(A5:A12). In cell F12 type =IF(A5>25,"Good Result","Bad"). This shows both the calculation and the outcome.

  • conehead
    Lv 6
    1 decade ago

    I don't think this is possible with just excel formulae, but why don't you put the formula in cell F12 instead? Then you'd have cell f12: =if(sum(a5:a12)>25, "Good Result", "Bad")

  • jondawg
    Lv 4
    1 decade ago

    I don't know if that's possible without VBA..

Still have questions? Get your answers by asking now.