HELP! with one formula in excel...

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • spamofon
    Confirmed User
    • Jun 2003
    • 2999
    #1

    HELP! with one formula in excel...

    i need to write this

    IF C4 > 10000 , then C4*0.3+C4
    IF C4< 10000, then C4*0.2+C4

    how do i put it in one line?
    Tags: None
    • tungsten
      Too lazy to set a custom title
      • Mar 2004
      • 10579
      #2
      bump, not big on excel myself
      • VOYEUR /HOMEMADE, HENTAI / CARTOON, Reality, Amateur, Shemale, Hardcore, Cuckold, Celebrity, Retro/Vintage, ect...ALL OUR SITES >>
      • Unbelievable Ratio | High % of Rebills | Bi-Monthly Payments (also to E-Passporte)
      • Ton's of EXCLUSIVE Free content & FHG's |=> GREAT REVENUE $$$ GUARANTEED!

        Comment

        • spamofon
          Confirmed User
          • Jun 2003
          • 2999
          #3
          nevermind

            Comment

            • spamofon
              Confirmed User
              • Jun 2003
              • 2999
              #4
              =if(c45<10000,0.2*c45,0.3*c45)

                Comment

                • ShaneRyale
                  Confirmed User
                  • Mar 2004
                  • 961
                  #5
                  Here you go.

                  =IF(C4 > 10000,C4*0.3+C4,C4*0.2+C4)
                  Shane - Affiliate Manager
                  [email protected]
                  ICQ: 170164556

                  See Who I Am At AdultWhosWho.com!

                    Comment

                    • spamofon
                      Confirmed User
                      • Jun 2003
                      • 2999
                      #6
                      How to make a Formula View of the spread sheet?

                        Comment

                        • spamofon
                          Confirmed User
                          • Jun 2003
                          • 2999
                          #7
                          Originally posted by spamofon
                          How to make a Formula View of the spread sheet?

                            Comment

                            Previous template Next
                            Working...