+ Reply to Thread
Results 1 to 3 of 3

If formula help

  1. #1
    Registered User
    Join Date
    01-09-2006
    Location
    Massachusetts
    MS-Off Ver
    Version 2402 Build 16.0.17328.20124)
    Posts
    60

    If formula help

    Hi,
    I am trying to write a formula that states If cell a1 = 4, then a1*5, if cell a1= 3, then a1*4 if a1 1 doesn't = 4 or 3, then a1 1*6.
    I'd appreciate any help you could provide.
    Last edited by Janie; 04-06-2009 at 03:31 PM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: If formula help

    =if(a1=4;a1*5;if(a1=3;a1*4;a1*6))

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: If formula help

    Wellcome to forum. Please make your names more precise when posting new question and don't forget to make it [solced] when you are satisfied with your answer

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1