Posted to microsoft.public.excel.worksheet.functions
|
|
formula help
"ozgrid.com" wrote:
=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(IF(I56,I5-0.5,I5)/24)))
--
Regards
Dave Hawley
www.ozgrid.com
"Jeff Brown" <Jeff wrote in message
...
I have a formula and can not make it work the way I would like.
=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) here it is.
I need it to subtract .50 from I5 if I5 is greater then 6.00
That would work I think but every time I do something like that it stops
displaying the result in the cell I5 it is just blank.
|