|
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
> 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?
|
adding equal/greater than into formula
Linear Mode
