Results 1 to 3 of 3

Nested If function

Threaded View

Lahiho Nested If function 12-13-2007, 11:12 AM
NBVC Try: ... 12-13-2007, 11:35 AM
Lahiho Ok, that works, thanks alot =) 12-13-2007, 11:42 AM
  1. 12-13-2007, 11:12 AM #1
    Lahiho is offline
    Registered User
    Join Date
    12-13-2007
    Posts
    2

    Nested If function

    I had this working before to a certain extent, then I changed something and it all went wrong
    =IF(H12<=0,"0%",IF(H12=3<="5","10%",IF(H12=6<=10,"15%","20%")))

    What I need is, that if 0 is in cell H12 "0%" is shown, if it is between 1 and 2 then "5%" is shown (I know I have completely missed it out of the formula, I realised after pasting it here, but that is not what the problem is) if it is between 3 and 5 then "10%" is shown, if it is between 6and 10 then 15% is shown and if it is anything else then 20% is shown.
    Last edited by Lahiho; 12-13-2007 at 11:24 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1