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