adding equal/greater than into formula

R

rvnwdr

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?
 
J

JE McGimpsey

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF statement - almost there! 5
An easier way? 8
Calculate Overtime double time 1
calculate overtime & doubletime 1
Adding Time from Name Range 2
Function Error 4
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
Greater than, less than, AS WELL AS value=0 5

Top