+ Reply to Thread
Results 1 to 3 of 3

Thread: =IF(AND(H21>198,H21<653),14.7,82.95) - but if H21=0,0?

  1. 07-07-2008, 05:23 AM #1
    amx1165
    amx1165 is offline
    Registered User
    Join Date
    06-28-2008
    Location
    Alabama
    Posts
    15

    =IF(AND(H21>198,H21<653),14.7,82.95) - but if H21=0,0?

    =IF(AND(H21>198,H21<653),14.7,82.95)

    What/how do I add to this so that if H21=0 then 0?
    Reply With Quote Reply With Quote
  2. 07-07-2008, 05:36 AM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    02-15-2008
    Location
    Grappenhall, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    6,566
    Hi

    =IF(H21=0,0,IF(AND(H21>198,H21<653),14.7,82.95))

    HTH
    Reply With Quote Reply With Quote
  3. 07-07-2008, 05:45 AM #3
    amx1165
    amx1165 is offline
    Registered User
    Join Date
    06-28-2008
    Location
    Alabama
    Posts
    15
    Whoop! Whoop!

    Thanks much
    Reply With Quote Reply With Quote
+ Reply to Thread
« 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.2.0