# adding equal/greater than into formula

1. ## adding equal/greater than into formula

Hi. This is relatively simple. I have the following existing formula in a spreadsheet:
=IF(G9=F9,"",IF(H9>10/24,16,IF(H9>5/24,8,0)))

Now - I would like it to calculate 8 if H9 is equal or greater than 5

Any sugestions?

2. =if(g9=f9,"",if(h9>10/24,16,if(h9>=5/24,8,0)))

3. ## Re: adding equal/greater than into formula

One way:

=IF(G9=F9,"",IF(H9>10/24,16,IF(H9>=5/24,8,0)))

Another:

=IF(G9=F9,"",8*((H9>=5/24)+(H9>10/24)))

In article <rvnwdr.1vtyaa_1127509503.6521@excelforum-nospam.com>,
rvnwdr <rvnwdr.1vtyaa_1127509503.6521@excelforum-nospam.com> wrote:

> Hi. This is relatively simple. I have the following existing formula
> =IF(G9=F9,"",IF(H9>10/24,16,IF(H9>5/24,8,0)))
>
> Now - I would like it to calculate 8 if H9 is equal or greater than 5
>
> Any sugestions?

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

#### 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