adding equal/greater than into formula
 

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

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

Any sugestions?


--
rvnwdr
------------------------------------------------------------------------
rvnwdr's Profile: http://www.excelforum.com/member.php...o&userid=23903
View this thread: http://www.excelforum.com/showthread...hreadid=470359

One way:

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

Another:

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



In article ,
rvnwdr wrote:

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

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

Any sugestions?

=if(g9=f9,"",if(h910/24,16,if(h9=5/24,8,0)))


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=470359